/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 votes308 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
3 votes312 views3 answers
Stop mysql service ubuntu
SQL
10 votes325 views1 answer
Query to find object dependencies in oracle
SQL
1 vote319 views1 answer
Error code 1055
SQL
0 vote313 views1 answer
What is between operator
SQL
1 vote332 views1 answer
Table infromation in sql server
SQL
4 votes313 views2 answers
Tables in sql
SQL
6 votes316 views5 answers
Get current date sql
SQL
0 vote321 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote336 views1 answer
Get create table query existing table mysql
SQL

Share