/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 vote369 views1 answer
SQL query to verify the size of the table
SQL
0 vote361 views1 answer
Mysql min value row
SQL
6 votes348 views1 answer
Check Table Exists
SQL
3 votes376 views1 answer
Start mysql server linux terminal
SQL
0 vote369 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
-1 vote336 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
18 votes353 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
6 votes368 views1 answer
Oracle rank
SQL
0 vote371 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote352 views1 answer
Mysql select all table that have field names
SQL

Share