--表不存在
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;