/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

0 vote178 views1 answer
Greater than or equal to symbol in postgres
SQL
37 votes187 views3 answers
Postgresql insert column
SQL
0 vote181 views1 answer
Top frequency in sql server
SQL
0 vote211 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote188 views1 answer
Postgres populate table from another table
SQL
0 vote188 views1 answer
Test connection to sql server
SQL
0 vote186 views1 answer
Show function mysql
SQL
1 vote189 views1 answer
Mysql backup skip table
SQL
1 vote183 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
5 votes145 views1 answer
Copy table from one database to another mysql
SQL

Share