/SQL/Reset auto increment in MySQL

Reset auto increment in MySQL

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

16

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

Reset auto increment in MySQL

ALTER TABLE tablename AUTO_INCREMENT = 1

1

Source: stackoverflow.com

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

Similar codes

0 vote206 views4 answers
Best data type to represent money in mysql
SQL
0 vote205 views1 answer
Sql server remove enter from string
SQL
0 vote216 views1 answer
Date on SQL
SQL
0 vote391 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote219 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
8 votes224 views1 answer
Check mysql version phpmyadmin
SQL
60 votes347 views6 answers
Add column in sql
SQL
8 votes209 views4 answers
Mysql update one table from another table multiple columns
SQL
14 votes236 views4 answers
Sql compiler
SQL
0 vote204 views1 answer
Mysql update sequence with order by
SQL

Share