/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 vote114 views1 answer
Left join in codeigniter query builder
SQL
0 vote133 views1 answer
Create bdd mysql
SQL
0 vote122 views1 answer
Mysql select inside sum
SQL
0 vote108 views1 answer
Check if a word appears at the end sql query
SQL
-2 votes114 views1 answer
Mysql see users and passwords
SQL
10 votes126 views2 answers
Show tables in schema oracle
SQL
0 vote118 views1 answer
Execute sql stored procedure in powershell
SQL
3 votes121 views2 answers
Oracle apex charging debug
SQL
-1 vote114 views4 answers
Postgres between dates
SQL
0 vote129 views1 answer
Wincc 7.4 to sql stackoverflow
SQL

Share