/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 votes284 views1 answer
How to check schema privileges in oracle
SQL
0 vote287 views1 answer
Search In the Data using ObjectName
SQL
0 vote309 views1 answer
Select all same column value in sql
SQL
3 votes309 views1 answer
Unsigned int in mysql
SQL
3 votes298 views1 answer
Dbms_scheduler drop_job
SQL
1 vote298 views1 answer
Mysql how to reset primary key
SQL
0 vote359 views1 answer
ALV GRID events
SQL
0 vote306 views1 answer
Mysql change innodb to myisam
SQL
0 vote306 views1 answer
Call function sql oracle with output put line
SQL
1 vote340 views1 answer
Mysql update inner
SQL

Share