close
1.只複製table的結構
select * into new_table from old_table where 1=0
2.完全複製table
select * into new_table from old_table
3.指定匯入某欄位至新的table
select a,b,c into new_table from old_table
4.將A table某欄位複製到B table某欄位
update B set B.column= (select A.column from A where A.column=B.column)
全站熱搜
留言列表
Linux (1)