Yahoo 知識+ 將於 2021 年 5 月 4 日 (美國東岸時間) 停止服務，而 Yahoo 知識+ 網站現已轉為僅限瀏覽模式。其他 Yahoo 資產或服務，或你的 Yahoo 帳戶將不會有任何變更。你可以在此服務中心網頁進一步了解 Yahoo 知識+ 停止服務的事宜，以及了解如何下載你的資料。
關於 MYSQL COPY TABLE Command
關於 MYSQL COPY TABLE Command
怎樣把 MYSQL 資料庫ABC的 TABLE：ONE， TABLE：TWO， TABLE：THREE, COPY TO 資料庫ABC的 TABLE：TOTAL．
thank a lot
easy9756
e.g.
TABLE ONE COST CENTER C1
TABLE TWO COST CENTER C2
TABLE THREE COST CENTER C3
e.g.
TABLE ONE STRUCTURE
COST CENTRE，ID，NAME．
TABLE ONE RECORD
C1, C1001, AAA
C1, C1002, BBB
TABLE TWO STRUCTURE
COST CENTRE，ID，NAME．
TABLE TWO RECORD
C2, C2001, CCC
C2, C2002, DDD
TABLE THREE STRUCTURE
COST CENTRE，ID，NAME．
TABLE THREE RECORD
C3, C3001, EEE
C3, C3002, FFF
1 個解答
- ?Lv 51 十年前最愛解答
if "TOTAL" is a existing table and u want to insert all records from tables "ONE", "TWO", "THREE". u can use following SQL.
INSERT into total ( cost_centre, id, name )
SELECT cost_centre, id, name FROM one
UNION ALL
SELECT cost_centre, id, name FROM two
UNION ALL
SELECT cost_centre, id, name FROM three.
If "TOTAL" isn't a existing table and u need to create it and to insert all records from tables "ONE", "TWO", "THREE". u can use following SQL.
CREATE TABLE total AS
SELECT cost_centre, id, name FROM one
UNION ALL
SELECT cost_centre, id, name FROM two
UNION ALL
SELECT cost_centre, id, name FROM three.