/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

1 vote143 views1 answer
Nullif postgresql
SQL
0 vote132 views4 answers
Sql year
SQL
6 votes145 views4 answers
Remove spaces sql server
SQL
1 vote145 views1 answer
Tsql replace value in json
SQL
0 vote127 views1 answer
Sql fetch next 10 rows pdo
SQL
2 votes132 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote136 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote152 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote173 views1 answer
Mysql 3 months ago
SQL
-1 vote173 views2 answers
Sql search all tables for attributes
SQL

Share