/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 vote174 views1 answer
Mysql insert into select transaction c#
SQL
1 vote186 views2 answers
How to add amount between date in sql
SQL
0 vote156 views1 answer
Create schema sql server
SQL
1 vote156 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote152 views2 answers
Sql drop view if exists
SQL
0 vote156 views1 answer
Sql add calculated column
SQL
5 votes151 views1 answer
Oracle ORA-00054 origin
SQL
1 vote206 views1 answer
Oracle check table lock
SQL
8 votes157 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote192 views1 answer
ORACLE PARSE STRING
SQL

Share