/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 vote138 views1 answer
First mysql
SQL
15 votes163 views4 answers
Export mysql db using command line
SQL
7 votes150 views1 answer
Query postgres delete duplicates
SQL
4 votes141 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
18 votes175 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote168 views1 answer
What is default mysql database password in linux
SQL
0 vote133 views1 answer
How to find unique key in sql
SQL
13 votes155 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
-1 vote141 views3 answers
Check table exist postgresql
SQL
0 vote257 views1 answer
Sql server query all database objects
SQL

Share