-- 表不存在 | |
create table tablename_backup as select * from tablename; | |
-- 表已存在 | |
truncate table tablename_backup; | |
insert into tablename_backup select * from tablename; | |
-- 数据从一张表转到另一张表 | |
insert into table1(username, password) select username, password from table2; |