/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 vote148 views1 answer
Mysql dump with table query
SQL
8 votes120 views2 answers
Update sql server from another table
SQL
-1 vote123 views3 answers
Create temp table in sql
SQL
2 votes140 views1 answer
Oracle percentage
SQL
1 vote128 views2 answers
Test sqlsrv connection
SQL
1 vote118 views3 answers
Read all columns of a table sql
SQL
0 vote130 views1 answer
How to select a row in sql
SQL
0 vote123 views1 answer
Can we rollback in sql
SQL
8 votes162 views3 answers
Postgres database sizes
SQL
4 votes133 views3 answers
Sql drop primary key
SQL

Share