MySQL defines the primary key as the autogrow identifier type

Share how the primary key is defined as the autogrow identifier type in MySQL.

1. Define the primary key as the auto-grow identifier type
In MySQL, if the primary key of the table is set to the Auto_increment type, the database is automatically assigned a value for the primary key. For example:

Create Table int Primary Key varchar ()); Insert  into Values ("Name1"), ("name2");

Once the ID is set to the Auto_increment type, the MySQL database automatically assigns a value to the primary key in an incremental manner.

In MS SQL Server, if the primary key of the table is set to the identity type, the database is automatically assigned a value for the primary key. For example:

Create Table int Identity (1,1primarykeyvarchar());--www.jbxue.com Insert  into Values ("Name1"), ("name2"); Select  from Customers;

The query results are the same as for MySQL. Thus, once the ID is set to the identity type, the MSSQLSERVER database automatically assigns a value to the primary key in an incremental manner.