/SQL/Create table mysql example auto_increment

Create table mysql example auto_increment

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

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

1 vote193 views2 answers
Intersect sql
SQL
10 votes154 views4 answers
Drop primary key
SQL
0 vote155 views1 answer
How to query without duplicate rows in sql
SQL
1 vote148 views1 answer
Group_concat order by
SQL
24 votes154 views6 answers
Sql change table name
SQL
0 vote152 views1 answer
Stored procedures example
SQL
1 vote155 views1 answer
Mysql backup skip table
SQL
10 votes136 views1 answer
Oracle dependency
SQL
2 votes167 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote321 views1 answer
Dublicate row sql
SQL

Share