/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 vote140 views1 answer
Eliminar ultimo carcacter mysql
SQL
2 votes143 views2 answers
Select list is not in group by clause
SQL
0 vote166 views1 answer
Mysql last friday of current month
SQL
10 votes132 views1 answer
Dba_dependencies
SQL
1 vote192 views1 answer
Find size of all DB's postgres
SQL
0 vote199 views1 answer
Sql server system messeges
SQL
8 votes151 views1 answer
Oracle search text in all packages
SQL
0 vote147 views2 answers
Sql query in dax power bi
SQL
0 vote142 views1 answer
Mysql count unique in group statement
SQL
0 vote95 views1 answer
Get all stored procedures in sql server
SQL

Share