/SQL/Mysql reset auto increment id

Mysql reset auto increment id

Mysql reset auto increment value

ALTER TABLE table_name AUTO_INCREMENT = 1;

18

Mysql reset auto increment

ALTER TABLE `Table Name` AUTO_INCREMENT = 1;

2

Mysql reset auto increment to 1

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 vote283 views1 answer
Plsql find location of procedure
SQL
1 vote315 views1 answer
STOP message of how many rows affected sql
SQL
0 vote275 views1 answer
SQL Query to delete all the tables in a database
SQL
-1 vote279 views5 answers
Online sql to linq generator
SQL
2 votes310 views3 answers
Xampp mysql database not starting
SQL
14 votes295 views4 answers
Import database through command line
SQL
11 votes294 views3 answers
Sql line numbers
SQL
0 vote300 views1 answer
T-sql update table variale
SQL
5 votes289 views2 answers
Sql number columns
SQL
3 votes286 views1 answer
Oracle sleep
SQL

Share