/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

0 vote208 views1 answer
Get substract count sql
SQL
0 vote148 views2 answers
Sql update from two different database
SQL
0 vote186 views1 answer
Mysql database hyphen
SQL
2 votes139 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote171 views3 answers
Rename table snowflake
SQL
0 vote179 views1 answer
Time in sql server
SQL
0 vote174 views1 answer
Mod in sql
SQL
1 vote184 views2 answers
Update with inner join sql server
SQL
4 votes167 views2 answers
What is table in sql
SQL
4 votes176 views3 answers
Check if two date ranges overlap sql server
SQL

Share