sql復制一個一模一樣的表 如何復制表?SQL?
如何復制表?SQL?1. 復制表結構和表內容的SQL語句:create tab uunew AS SELECT*FROM tab uuold2。只復制表結構而不復制表內容的SQL語句:create t
如何復制表?SQL?
1. 復制表結構和表內容的SQL語句:create tab uunew AS SELECT*FROM tab uuold
2。只復制表結構而不復制表內容的SQL語句:create tab new AS SELECT*FROM tab Old where 1=2
3。不復制表結構,只復制SQL語句的內容:insert into tab new select*from tab Old或select value1,Value2 into table2 from table1