close
INSERT INTO TABLE1名稱 (欄位1, 欄位2, ...)
SELECT 欄位3, 欄位4, ...
FROM TABLE2名稱
UPDATE TABLE1
SET TABLE1.欄位1 = TABLE2.欄位1
FROM TABLE2 WHERE TABLE2.欄位1 = TABLE1.欄位1
-----------------------------------------------------------------
加碼附贈:
備份單一資料表時可用以下指令:
SELECT * INTO 備份檔名(bkp) FROM 要備份的檔;
----------------------------------------------------------------
新收穫:
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
order by table_name
可以列出整個DB的TableList
全站熱搜
留言列表