Home > database >  Mysql data update primary key on the question
Mysql data update primary key on the question

Time:10-30


When I when to update the data by using the replace into statements, lead to the primary key q_id since, q_id configuration is: ` q_id ` int (11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'on the id, and the other table q_id association, each update of the other table data is changed, in fact every time I just update q_tag, then the other table by q_id association, how to do ability to let q_id NOT update, q_tag is fixed, no update, at the same time q_id corresponding + 1 is ok

CodePudding user response:

With the update
  • Related