Posts by Walbert Soares de Olivera • 1 point

• 0

  votes

  1

  answer

  47

  views

  A: Mysql trigger to insert the desired id

  I solved the problem using: auto_increment_increment e auto_increment_offset. thus: auto_increment_increment = 10 auto_increment_offset = 2 So the id will be filled in this way: id 2 12 22 32 ...…

  mysql

  answered 4 years, 5 months ago Walbert Soares de Olivera 1

• 0

  votes

  1

  answer

  47

  views

  Q: Mysql trigger to insert the desired id

  I have two mysql and sqlserver databases, I share the same data with each other, but in order not to have id conflict numerei each mysql database = 2, sqlserver = 1, I would like the table id to be…

  mysql

  asked 4 years, 5 months ago Walbert Soares de Olivera 1