/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

23 votes194 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote353 views1 answer
How to use select union and loop
SQL
1 vote338 views1 answer
Sql check roles
SQL
7 votes192 views4 answers
What is my mysql version
SQL
0 vote186 views1 answer
Order by ip address sql
SQL
2 votes203 views2 answers
Mysql count rows returned
SQL
0 vote185 views1 answer
Create a table from one field of another table
SQL
0 vote203 views1 answer
How to find database collation in postgres
SQL
0 vote202 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote217 views1 answer
Sql sort ages
SQL

Share