Bug #83781 Insert manual page does not adequately show how to handle auto_increment columns

• Submitted: 11 Nov 2016 2:42
• Modified: 31 Jul 2018 14:51
• Reporter: Peter Brawley (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[11 Nov 2016 2:42] Peter Brawley

Description:
The manual page for Inserts, http://dev.mysql.com/doc/refman/5.7/en/insert.html, fails to explain adequately for noobies how to write Inserts for a table with an auto_increment column.

For an example of a Newbie affected by this documentation oversight, see this Newbie forum thread: http://forums.mysql.com/read.php?10,652406,652406#msg-652406

How to repeat:
As above

Suggested fix:
Provide explicit examples using both VALUES() and SET... syntax.

[11 Nov 2016 4:40] MySQL Verification Team

Hello Peter,

Thank you for the report and feedback!

Thanks,
Umesh

[11 Nov 2016 4:41] MySQL Verification Team

Some more details covered here - http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

[11 Nov 2016 4:50] Peter Brawley

Umesh> Some more details covered here -
> http://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

That's about a third of what a Newbie need to know, and the Insert oage does not link even to that partial info.

[31 Jul 2018 14:51] Daniel Price

Posted by developer:
 
The "Using AUTO_INCREMENT" tutorial page was updated with additional INSERT examples.
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html

A reference was added from the "INSERT Syntax" page to the "Using AUTO_INCREMENT" tutorial page.

The changes should appear online in a few hours.

Thank you for the bug report.