/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 vote128 views1 answer
Oracle lowercase
SQL
2 votes140 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
8 votes126 views2 answers
Mysql get first x characters
SQL
0 vote153 views1 answer
Synapse sql table set pk
SQL
2 votes143 views3 answers
Oracle show column of table
SQL
-1 vote120 views1 answer
Add column alter table default value
SQL
4 votes116 views2 answers
Postgres update single column
SQL
0 vote128 views1 answer
Procedure excute monthly oracle
SQL
0 vote136 views1 answer
How to reset the database value in SQL server
SQL
1 vote164 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL

Share