/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

13 votes245 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
4 votes348 views2 answers
Sql display today's date
SQL
0 vote206 views1 answer
Mysql docker image arjun
SQL
2 votes252 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
12 votes205 views2 answers
Select into insert sql server
SQL
0 vote272 views1 answer
Mssql describe stored procedure sqlcmd
SQL
11 votes204 views1 answer
Get ddl materialized view oracle
SQL
0 vote214 views2 answers
Sql join on comma separated field
SQL
0 vote159 views1 answer
Check sql query executed wp
SQL
3 votes215 views2 answers
Sqlite print all column names
SQL

Share