INSERT INTO
表名(字段一,字段二, 字段三) SELECT 字段一, 字段二,字段三 FROM 表名
WHERE
条件
--------------------------------------------------------------------------
例:
Field Type Null Key Default Extra
id int(11) unsigned NO PRI NULL auto_increment
name varchar(50) NO NULL
pass varchar(50) NO NULL
INSERT INTO users(name,pass) SELECT users.name, users.pass FROM users WHERE users.id =1
修改某字段值
INSERT INTO
表名(字段一,字段二, 字段三) SELECT 值, 字段二,字段三 FROM 表名
WHERE
条件
例：
INSERT INTO orderdetails(orderid,drawingid,number,carnumber,remark ) SELECT 100 , drawingid,number,carnumber,remark FROM orderdetails WHERE orderid = 92
