/SQL/Delete auto increment mysql

Delete auto increment mysql

Mysql auto increment after delete

set @autoid :=0; 
update Table_Name set AutoIncremented_Column = @autoid := (@autoid+1);
alter table Table_Name Auto_Increment = 1;

@Zenonymous

1

Source: grepper.com

Mysql remove auto increment

ALTER TABLE mytable CHANGE my_col my_col INT(10) UNSIGNED NOT NULL

0

Source: sitepoint.com

Similar codes

1 vote324 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote339 views1 answer
Login failed for login due to trigger execution
SQL
0 vote336 views2 answers
How to know the character set of an oracle databes
SQL
3 votes352 views1 answer
Postgres kill running query
SQL
0 vote361 views1 answer
Data directory postgresql
SQL
0 vote326 views1 answer
Download mysql database to excel in android studio
SQL
9 votes346 views1 answer
Mysql check date range
SQL
0 vote371 views1 answer
Time data type in mysql
SQL
1 vote329 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote355 views1 answer
Mysql listing get a particu particular user firsdt
SQL

Share