/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

0 vote158 views1 answer
Mysql delete from where like
SQL
4 votes139 views1 answer
Sql query to make a existing column auto increment
SQL
-1 vote178 views3 answers
Error: mysql shutdown unexpectedly.
SQL
1 vote145 views1 answer
Oracle difference between two dates in years
SQL
0 vote132 views1 answer
Sql view index
SQL
0 vote142 views1 answer
Change schema of all tables postgres
SQL
0 vote149 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote143 views1 answer
Mysql shell ERROR: Not connected.
SQL
3 votes136 views1 answer
APEX elapsed time
SQL
2 votes211 views2 answers
How to DROP a table in mysql
SQL

Share