behavior and documents conflict for SELECT LAST_INSERT_ID()
Chenxi Li <[email protected]> Fri, 21 Apr 2017 16:38:13 +0800
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <CAJQBB7+g+FOXGrB-iXGQ8Ox9KwPm_Su9PWew+JQaVn5z83VXVQ@mail.gmail.com> |
Dear friends, 1. https://bugs.mysql.com/bug.php?id=78934 2. https://dev.mysql.com/doc/refman/5.7/en/information-functions.html#function_last-insert-id The document (2) says that LAST_INSERT_ID() will not be changed if no rows are inserted successfully. But (1) says that it's undefined when no rows are inserted successfully, which is in real case. What is the problem? the document or the code? Best Regards, Chenxi Li