/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

3 votes156 views1 answer
Get current month last date in sql server
SQL
14 votes1.1K views1 answer
Sql value of string
SQL
18 votes150 views4 answers
Uninstall mysql ubuntu 18.04
SQL
4 votes171 views2 answers
Tables in sql
SQL
0 vote188 views1 answer
Wordpress make wp user in db
SQL
2 votes160 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote162 views1 answer
Soql user profile
SQL
36 votes170 views3 answers
Add column in mysq
SQL
0 vote142 views2 answers
How to set global time_zone in mysql
SQL
0 vote156 views1 answer
Oracle synonym procedure dblink
SQL

Share