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

Let's learn about the pymysql.err.Internal 107error. I believe you will benefit a lot after reading it. The text is not in the essence. I hope the short article of pymysql.err.Internal 107error is what you want.

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)

)''

After reading the pymysql.err.Internal error article, many readers will want to know more about it. If you need more industry information, you can follow our industry information section.

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.