/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 vote259 views1 answer
Sqlite display data in separated columns
SQL
1 vote133 views3 answers
Default password of mysql
SQL
4 votes129 views4 answers
Date less than in sql
SQL
1 vote137 views1 answer
How to unlock table in mysql
SQL
1 vote118 views1 answer
Reutrn string after character sql
SQL
4 votes129 views3 answers
How to describe a table in sqlite3
SQL
20 votes137 views1 answer
Sql change column types
SQL
0 vote134 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote84 views1 answer
Kannst du deine finger trainieren
SQL
5 votes130 views3 answers
Sql make column nullable
SQL

Share