Home > database >  * * * * * * mysql Duplicate entry for 1 key PRIMARY * * * * * *
* * * * * * mysql Duplicate entry for 1 key PRIMARY * * * * * *

Time:09-26

Dear god,
1, 15 with mysql Navicat for mysql data conversion sql2008 (normal), with the data in the data table, and id not repeat, and finally a id to about 1000 or so
2, but running add data code (insert into) will prompt the Duplicate entry XX for key PRIMARY PRIMARY key error
3, already set id primary key and automatically growth
4, the problem is: each time add data id or starting from 1, next to the 2... By analogy, the primary key conflict, how to return a responsibility? According to conventional, should automatically start from 1001 o
5, version mysql8.0.0.18

CodePudding user response:

Do me a help, the great god
  • Related