直接将全部变量复制,不做任何值更改
INSERT INTO XXX
( SELECT * FROM XXX ) //注意没有value
带参数变量的插入
INSERT INTO XXX ( id, xxx, xxx)
( SELECT id, xxx, xxx FROM XXX )
INSERT INTO XXX
( SELECT * FROM XXX ) //注意没有value
INSERT INTO XXX ( id, xxx, xxx)
( SELECT id, xxx, xxx FROM XXX )