The solution to the problem of self-increasing ID of MySQL Sub-table

This article mainly explains the "MySQL sub-table self-increasing ID problem solution", the article explains the content is simple and clear, easy to learn and understand, now please follow the editor's train of thought slowly in depth, together to study and learn "MySQL sub-table self-increasing ID problem solution"!

When we split the MySQL, we will not be able to rely on the automatic increment of the MySQL to generate a unique ID, because the data has been scattered across multiple tables.

The use of self-increasing IP as the primary key should be avoided as far as possible, which brings great inconvenience to the operation of database tables.

There is a special feature in postgreSQL, oracle, db2 databases-sequence. At any time, the database can get the number of records under the table according to the number of records and step size in the current table. However, MySQL does not have such sequence objects.

You can implement the sequence feature to generate a unique ID in the following ways:

1. Generate ID from MySQL table

For the insert, which is the insert operation, the first thing to do is to get the unique id, and you need a table to create the id, insert a record, and get the last inserted ID. The code is as follows:

CREATE TABLE `ttlsa_ com`.`create _ id` (`id` BIGINT (20) NOT NULL AUTO_INCREMENT PRIMARY KEY) ENGINE = MYISAM

That is, when we need to insert data, this table must generate the id value. My php code works as follows: