/SQL/Mysql set id auto increment

Mysql set id auto increment

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

Auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;

2

Mysql reset auto increment id

SET  @num := 0;

UPDATE your_table SET id = @num := (@num+1);

ALTER TABLE your_table AUTO_INCREMENT =1;

1

Source: stackoverflow.com

Mysql check auto increment value

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

0

Similar codes

2 votes125 views1 answer
Set username and password for postgresql database
SQL
0 vote111 views1 answer
Create api project in visual studio 2019 and sql server
SQL
15 votes213 views3 answers
Postgresql change column type
SQL
13 votes129 views4 answers
Mysql select last 10 rows
SQL
0 vote129 views1 answer
Write sql query to show the details start from digit
SQL
4 votes133 views1 answer
Oracle user tables
SQL
0 vote124 views1 answer
Sql gather statistics to increase performance
SQL
5 votes145 views1 answer
Oracle list functions
SQL
0 vote136 views1 answer
Mysql c commands
SQL
0 vote137 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL

Share