/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

3 votes228 views1 answer
Oracle list privileges
SQL
0 vote233 views1 answer
Sql tabelle erstellen
SQL
1 vote214 views1 answer
Create table variable in sql stored procedure
SQL
6 votes215 views3 answers
Mysql change auto_increment start value
SQL
0 vote207 views1 answer
Truncate table sql server foreign key
SQL
0 vote215 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote249 views1 answer
Joomla execute raw sql
SQL
4 votes284 views1 answer
Oracle table statistics
SQL
0 vote209 views1 answer
Mysql select last 15 minutes
SQL
0 vote217 views1 answer
How to find username and password in oracle 18c
SQL

Share