/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

25 votes232 views5 answers
Mysql replace text
SQL
2 votes168 views2 answers
How to get capital letter first in sql
SQL
4 votes183 views1 answer
Check database name postgresql
SQL
0 vote181 views1 answer
Android sqlite get rows count
SQL
1 vote267 views2 answers
Sql example query
SQL
1 vote183 views1 answer
Alphabetical order mysql
SQL
2 votes138 views2 answers
Mysql get last character of string
SQL
0 vote205 views1 answer
Frename oracle
SQL
0 vote250 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote194 views1 answer
Mysql average from two table
SQL

Share