INSERT INTO 目標(biāo)表 SELECT * FROM 來源表 WHERE 條件;

INSERT INTO newStudent SELECT * FROM student;

INSERT INTO 目標(biāo)表(字段1,字段2,...) SELECT 字段1,字段2,... FROM 來源表 WHERE 條件;

INSERT INTO `litemall_company_enter`
(user_id,`name`,`type`,`time`,number,price,link,brief,product,`code`,legal_person,phone,email,address,`sign`,add_time,update_time,deleted)
SELECT
-1,t.`name`,t.`type`,t.`time`,t.number,t.price,t.link,t.brief,t.product,t.`code`,t.legal_person,t.phone,t.email,t.address,1,NOW(),NOW(),0
FROM `litemall_company_enter_temporary` t
WHERE t.id IN (2,4,6)

INSERT INTO 目標(biāo)表(字段1, 字段2, …) SELECT 字段1, 字段2, … FROM 來源表 
WHERE NOT exists (SELECT * FROM 目標(biāo)表 WHERE 目標(biāo)表.比較字段 = 來源表.比較字段);

INSERT INTO `litemall_company_enter`
(user_id,`name`,`type`,`time`,number,price,link,brief,product,`code`,legal_person,phone,email,address,`sign`,add_time,update_time,deleted)
SELECT
-1,t.`name`,t.`type`,t.`time`,t.number,t.price,t.link,t.brief,t.product,t.`code`,t.legal_person,t.phone,t.email,t.address,1,NOW(),NOW(),0
FROM `litemall_company_enter_temporary` t
WHERE NOT EXISTS
(SELECT * FROM `litemall_company_enter` e WHERE e.name=t.name AND e`.code=t.code )

SELECT * INTO student_backups FROM student WHERE class='高三(2)班';

SELECT name,age,student_num INTO student_backups FROM student WHERE class='高三(2)班';

SELECT * INTO student IN 'Backups.mdb' FROM student WHERE class='高三(2)班';

SELECT s.name,t.id INTO teacher_student_backups FROM student s INNER JOIN teacher t ON s.tid=t.id;

`INSERT INTO a(id,name)?
SELECT ?b.id as id,b.name as name FROM b;`?

INSERT INTO dim_attach (type,bill_id,url,create_date) select ?'name', ?a.id AS bill_id, a.head_address AS url,now()
FROM
?dim_people a