/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 vote323 views2 answers
What is the default password for sql server sa
SQL
-1 vote287 views2 answers
How to display top 50 rows?
SQL
1 vote316 views2 answers
How to check if sql query is correct online
SQL
0 vote324 views1 answer
Incorrect string value: mysql
SQL
0 vote318 views4 answers
Stored procedure sql
SQL
-2 votes338 views3 answers
How to fetch first 10 rows in sql
SQL
5 votes307 views2 answers
Copy data from one database to another
SQL
0 vote319 views1 answer
Transalations from sql to Linq count and group by
SQL
8 votes325 views3 answers
Alter user root mysql
SQL
0 vote311 views1 answer
Setting default value for Boolean data type in SQL
SQL

Share