Bug #38105 Clarify VALUE as a synonym for VALUES in INSERT
Submitted: 14 Jul 2008 14:58 Modified: 17 Jul 2008 16:54
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version:all OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[14 Jul 2008 14:58] Kay Roepke
Description:
http://dev.mysql.com/doc/refman/5.1/en/insert.html gives the syntax description:

{VALUES | VALUE} ({expr | DEFAULT},...),(...),...

for an insert statement, but the text does not clarify that VALUE is just a synonym for VALUES.
It might be taken as only allowing one row to be inserted, but that is not so:

How to repeat:
Read docs, execute statement below:

mysql> insert into test (a,b) value (2,3),(3,4);
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0

INSERT INTO .. VALUE (),() is a legal statement.

Suggested fix:
Put in a short comment where VALUES is discussed that both VALUE and VALUES can be used interchangeably.
[14 Jul 2008 15:04] Jon Stephens
Assigned to Paul at his request.
[17 Jul 2008 16:54] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.