mysql做数据迁移，把A库a表数据复制到B库b表

[liyu0815]

sql语句如：
INSERT INTO A.a VALUES(
SELECT 字段1,字段2 FROM B.b
);

错误如下：错误代码： 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select help_category_id,name,parent_category_id,url from mysql.`help_category`
)' at line 2


请问这是什么问题呢？

[rucypli]

INSERT INTO A.a SELECT 字段1,字段2 FROM B.b

[LongRui888]

楼上正解

[zjcxc]

看下官网文档的 insert 语法嘛

[liyu0815]

我一直加了个values，原来不要values，感谢二楼