Import the data to the mysql database in Python times wrong-CodePudding

Home > database > Import the data to the mysql database in Python times wrong

Import the data to the mysql database in Python times wrong

Time：12-21

While importing XLSX table data into the database, an error: pymysql. Err. IntegrityError: (1062, "Duplicate entry '18110506036' for key 'PRIMARY'")

SQL: SQL="INSERT INTO student_k1 (id, name, Chinese, math, English) VALUES (% s, % s, % s, % s, % s) '

Page link：https//www.codepudding.com/database/95310.html

Prev:The mysql database user table this is the encrypted password field? Or the code??

Next:On how to insert the contents of frequent search database

Tags：

The base class

Links：
CodePudding