把库cs1cs1中的user表内多个字段,导入cscs2数据库中的user对应字段这是我根据网上写的代码,但是老是报错insert into cs2cs2.user(id,username,password,email,mobile,mobile_test,qq) values select id,username,password,email,mobile,mobile_test,qq from cs1cs1.user;以下是报错内容ERROR 1064 (42000): 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 'insert into cs2cs2.user(id,username,password,email,alipay,realname,ji' at line 2求助
SELECT id,username,password,email,mobile,mobile_test,qq
FROM cs1cs1.user没有 values 的吧。
insert into .... select * from 。 没有values 这个关键字。
[INTO] tbl_name [(col_name,...)]
VALUES ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
或:INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
或:INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE col_name=expr, ... ]
insert into (name,……)tbname select name,…… from tb1