/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

5 votes314 views2 answers
Oracle rename table
SQL
8 votes333 views1 answer
Racle create auto increment column
SQL
4 votes306 views2 answers
Mysql select where starts with
SQL
0 vote321 views1 answer
Linebreak sql
SQL
0 vote323 views1 answer
With_for_update sqlalchemy
SQL
0 vote326 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote316 views1 answer
Alter owner in PostgreSQL
SQL
2 votes343 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
3 votes312 views1 answer
Postgres update column with value from another table
SQL
-1 vote309 views1 answer
Ssql to lowercqse
SQL

Share