我能在MySQL INSERT查询中使用LIMIT 2吗?例如:
INSERT INTO MyTable
(user_name,password)
VALUES
(john,366543),
(sam,654654)
LIMIT 2
我尝试了,它显示:
`#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 'LIMIT 2' at line 1`
INSERT INTO ... SELECT FROM
中使用LIMIT
就像这里演示的那样是相关的。 - tadman