/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 vote261 views1 answer
Wordpress sql change site url
SQL
0 vote286 views1 answer
Mysql enter ubuntu
SQL
0 vote348 views1 answer
How to check foreign key constraint in sql
SQL
28 votes244 views6 answers
Distinct sql
SQL
8 votes279 views1 answer
Oracle tablespace datafile max size
SQL
1 vote285 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
1 vote278 views1 answer
Sql eliminare un record
SQL
0 vote260 views1 answer
Sql select rows between 1000 and 2000
SQL
3 votes298 views2 answers
Order by postgresql
SQL
0 vote305 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL

Share