SELECT INTO TABLE Differences
MySQL Server 不支持SELECT ... INTO TABLE ,
但MySQL Server 支持 INSERT INTO ... SELECT 标准的SQL,
For example:
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
UPDATE 区别:
例如:
UPDATE t1 SET col1 = col1 + 1, col2 = col1;
在MY SQL,col2=col1,这个COL1其实是原来的col1+1;不是原本的col1