Shulou(Shulou.com)06/01 Report--

Pymysql.err.InternalError: (1075, 'Incorrect table definition; there can be only one auto column and it must be defined as a key')

To create a table using pymysql in python is to report an error. The above title is the sql statement as follows:

Sql ='

Create table music (

Id int not null auto_increment

Song text

Singer text

Genre text

Issue text

Publisher text

Score text)''

Baidu, the problem is: the self-increasing field must be the primary key. The solution is to set id as the primary key.

The modified sql is:

Sql ='

Create table music (

Id int not null auto_increment

Song text

Singer text

Genre text

Issue text

Publisher text

Score text

Primary key (id)

)''

Thank you: https://www.cnblogs.com/guodongdidi/p/6290782.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.