/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 vote138 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote135 views1 answer
What is between operator
SQL
1 vote145 views1 answer
Sql week commencing date
SQL
1 vote138 views1 answer
Sql server cast date dd/mm/yyyy
SQL
4 votes146 views2 answers
Postgresql default value
SQL
4 votes135 views1 answer
Mysql copy table with new name
SQL
0 vote145 views2 answers
Mysql dump database tables only
SQL
1 vote151 views2 answers
Restart identity cascade
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL
1 vote158 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL

Share