/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 vote141 views1 answer
Alternative for LIMIT sql
SQL
0 vote112 views1 answer
Oracle grant create job
SQL
0 vote116 views1 answer
Subquery aggregation
SQL
2 votes121 views2 answers
Mysql bidirectional composite primary key
SQL
13 votes100 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote181 views1 answer
Generate a random otp in sql server
SQL
0 vote119 views1 answer
Write sql query to show the details start from digit
SQL
0 vote135 views1 answer
Oracle dynamic select into
SQL
0 vote118 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote116 views1 answer
TSQL function split string
SQL

Share