/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 vote116 views1 answer
Teller stamp , bmo , PDF
SQL
1 vote118 views1 answer
Show table columns
SQL
3 votes126 views1 answer
Postgres select max value
SQL
1 vote121 views1 answer
Oracle create program if no exists
SQL
0 vote144 views1 answer
Time data type in mysql
SQL
0 vote120 views1 answer
How to output a different column name in mysql
SQL
1 vote132 views3 answers
Rows, INSERT INTO
SQL
0 vote119 views1 answer
MySql Modify Increment
SQL
3 votes159 views2 answers
Update part of a string in mysql
SQL
3 votes184 views2 answers
Oracle privileges users
SQL

Share