/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 vote578 views1 answer
The differnece between to values in sql
SQL
0 vote367 views1 answer
Sqlalchemy get schema from database
SQL
0 vote401 views1 answer
Mysql create index lost connection
SQL
11 votes408 views2 answers
Import mysql dump command line windows
SQL
0 vote331 views1 answer
Is not null postgresql
SQL
0 vote369 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote381 views1 answer
Login failed for user sql server
SQL
25 votes353 views6 answers
Change column name mysql
SQL
0 vote355 views1 answer
WHERE not regex in SQL
SQL
0 vote352 views1 answer
Sql server sleep
SQL

Share