/SQL/Change auto increment mysql

Change auto increment mysql

Make a field auto_increment mysql

ALTER TABLE document MODIFY COLUMN document_id INT auto_increment

3

Source: stackoverflow.com

Auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;

2

Change auto increment mysql

ALTER TABLE tbname MODIFY COLUMN columname smallint(5) auto_increment

1

How to change the auto increment in existing table mysql

ALTER TABLE tbl_access ADD COLUMN `access_id` int(10) NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST

-1

Source: stackoverflow.com

Similar codes

13 votes139 views3 answers
Sql select from multiple tables without join
SQL
0 vote123 views1 answer
Drop procedure sql
SQL
0 vote115 views1 answer
Sql string contains case sensitive
SQL
31 votes124 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote112 views1 answer
Postgres check blocking
SQL
8 votes81 views1 answer
Oracle current date plus 1 month
SQL
0 vote118 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
36 votes122 views6 answers
Rename table sql
SQL
3 votes141 views3 answers
Sql current year
SQL
0 vote125 views1 answer
Django mysqlclient connection string
SQL

Share