您只需要做:
INSERT INTO def (catid, title, page, publish)
SELECT catid, title, 'page','yes' from `abc`
mysql->插入到tbl(从另一个表中选择)和一些默认值[重复]
您只需要做:
INSERT INTO def (catid, title, page, publish)
SELECT catid, title, 'page','yes' from `abc`