How to create an auto-increment field in MySQL _ MySQL

Source: Internet
Author: User
This article mainly introduces how to create a field that cannot be automatically added in MySQL. This article can solve the problem that causes auto_increament to fail. For more information, see Cause analysis:

The reason why MySQL cannot create automatically added fields is that several SQL _modes are added in The Server SQL Mode in MySQL 5.0.2, and in The SQL my. two types of SQL-mode are added by default in the INI file. one is STRICT_TRANS_TABLES, which is the mode that causes auto_increament to fail. this SQL _mode is mainly used when a value cannot be inserted into the table, an error is generated instead of a warning and the session is terminated.

Solution:

Delete or comment out SQL _mode. restart mysql.

In my. ini:

The code is as follows:


# Set the SQL mode to strict

SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Changed:

The code is as follows:

# Set the SQL mode to strict [separator]

# SQL-mode = "STRICT_TRANS_TABLES, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

SQL-mode = "NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION"

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.