create table business_copy as select * from business; 注:create table:創(chuàng)建表的關(guān)鍵字 as select * from business:把business中的數(shù)據(jù)全部復制到business_copy中(不復制表的約束) 6、把備份表中的數(shù)據(jù)導入新表 復制代碼代碼如下: insert into business(busino,businame,itemno,starttime) select * from busin...