select * into 备份表1 from 表1
备份前不需要创建备份表1,直接执行上面代码即可
若表A,B字段一致,把表B的内容插入到A中
insert * into A from B
mysql:CREATE TABLE users_backup SELECT * FROM users;
若表M,N有外键id相连,查出M,N表中id相同的记录
select * from M,N where M.id=N.id
select * into 备份表1 from 表1
备份前不需要创建备份表1,直接执行上面代码即可
若表A,B字段一致,把表B的内容插入到A中
insert * into A from B
mysql:CREATE TABLE users_backup SELECT * FROM users;
若表M,N有外键id相连,查出M,N表中id相同的记录
select * from M,N where M.id=N.id
转载于:https://www.cnblogs.com/lxboy2009/p/4371324.html