MySQL Bugs: #38105: Clarify VALUE as a synonym for VALUES in INSERT

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

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.

Assigned to Paul at his request.

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.