How to customize mysql primary key id

This article mainly introduces the mysql key id how to achieve customization, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Execute the following sql statement

Alter table user (table name) AUTO_INCREMENT=800008 (where do you want the primary key id to start)

MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS (Relational Database Management System: relational database management system) applications in WEB applications.

What is a database?

Database (Database) is a warehouse that organizes, stores and manages data according to the data structure.

Each database has one or more different API for creating, accessing, managing, searching, and replicating saved data.

We can also store data in a file, but it is relatively slow to read and write data in the file.

So now we use a relational database management system (RDBMS) to store and manage large amounts of data. The so-called relational database is a database based on the relational model, which deals with the data in the database with the help of mathematical concepts and methods such as set algebra.

RDBMS is the characteristics of relational database management system (Relational Database Management System):

1. The data appears in tabular form.

two。 Various record names for each behavior

3. The data field corresponding to the record name of each column

4. Many rows and columns form a form

5. Several forms make up database

Thank you for reading this article carefully. I hope the article "how to customize the mysql key id" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!