This MOVES a table alter table abc.users rename xyz.users This duplicates (makes a clone of) a table CREATE TABLE db1.table1 SELECT * FROM db2.table1
alter table abc.users rename xyz.users
CREATE TABLE db1.table1 SELECT * FROM db2.table1