INSERT INTO "table_name" ("column1", "column2", ...)
VALUES ("value1", "value2", ...)
INSERT INTO "table1" ("column1", "column2", ...)
SELECT "column3", "column4", ...
FROM "table2"
Note that this is the simplest form. The entire statement can easily contain WHERE, GROUP BY, and HAVING clauses, as well as table joins and aliases.
2008年3月25日 星期二
訂閱:
張貼留言 (Atom)
沒有留言:
張貼留言