/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

31 votes173 views4 answers
Mysql grant execute
SQL
9 votes137 views4 answers
Mysql show table fields
SQL
5 votes145 views2 answers
Sql constraint check value in list
SQL
-1 vote173 views4 answers
Sql view postgresql
SQL
0 vote143 views1 answer
Oracle exchange partition
SQL
1 vote141 views1 answer
Rename table column name in mysql
SQL
-1 vote140 views1 answer
Io
SQL
1 vote266 views2 answers
Postgres select from last 3 months
SQL
1 vote147 views1 answer
Name of today sql
SQL
0 vote144 views1 answer
How to get specific salary in sql
SQL

Share