MySQL 不支援標準 SQL 的 SELECT ... INTO table_name FROM ... 建表並寫入語法。 嘗試執行會報錯 #1327 - Undeclared variable。
CREATE TABLE new_table AS
SELECT id, pic_url, pic_thumb, pic_desc, borough_id, creater, addtime
FROM test_table_draw
WHERE borough_id BETWEEN 10266 AND 12354;
INSERT ... SELECT。INSERT INTO test_table_tp (id, pic_url, pic_thumb, pic_desc, borough_id, creater, addtime)
SELECT id, pic_url, pic_thumb, pic_desc, borough_id, creater, addtime
FROM test_table_draw
WHERE borough_id BETWEEN 10266 AND 12354;
AUTO_INCREMENT 主鍵,可略過該欄位或傳 NULL。#1136 - Column count doesn't match value count at row 1 → 明確列出欄位清單,避免 SELECT *。INTO 解析為「變數賦值」,而非建表 → 改用 CTAS。CREATE TABLE new_tbl AS SELECT a.id, b.name FROM a JOIN b ... 完美支援。CREATE TABLE new_table LIKE old_table; -- 複製結構、索引、約束
INSERT INTO new_table SELECT * FROM old_table WHERE ...; -- 再導資料
MySQL 中「查詢結果建新表」請使用 CREATE TABLE ... AS SELECT;「寫入既有表」用 INSERT ... SELECT。切勿嘗試標準 SQL 的 SELECT INTO table,會被誤判為變數賦值導致語法錯誤。