forum

Home / DeveloperSection / Forums / How to set column as AUTO_INCREMENT in MySQL

Ask Question

How to set column as AUTO_INCREMENT in MySQL

Sandra Emily 164 27-Jul-2023

How to set a column as AUTO_INCREMENT  in MySQL

mysql database  mysql 
Updated on 28-Jul-2023
Sandra Emily

Sandra Emily

Follow
Content writing is the process of writing, editing, and publishing content in a digital format. That content can include blog posts, video or podcast scripts, ebooks or whitepapers, press releases, product category descriptions, landing page or social media copy and more.

Can you answer this question?

Answer

1 Answers

Aryan Kumar

Aryan Kumar

28-Jul-2023

To set a column as auto_increment in MySQL, you can use the AUTO_INCREMENT keyword when creating the table. The syntax is as follows:

SQL

CREATE TABLE table_name (
  column_name INT NOT NULL AUTO_INCREMENT,
  other_column_name VARCHAR(255) NOT NULL,
  ...
);

For example, the following SQL statement will create a table called products with a column called id that is auto_incremented:

SQL

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);

Once you have created the table, you can insert new rows into the table without specifying a value for the id column. MySQL will automatically increment the value of the id column for each new row that you insert.

Here are some additional things to keep in mind about auto_increment columns:

  • The AUTO_INCREMENT keyword can only be used with integer columns.
  • The starting value for the AUTO_INCREMENT column is 1.
  • The AUTO_INCREMENT column will increment by 1 for each new row that you insert.
  • You can change the starting value for the AUTO_INCREMENT column by using the ALTER TABLE statement.
MindStick Training

Liked By