/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

0 vote277 views3 answers
Sql drop all tables
SQL
4 votes262 views1 answer
Oracle user tables
SQL
0 vote281 views1 answer
Sql shell psql cannot enter password
SQL
0 vote377 views1 answer
ORA-01400
SQL
4 votes311 views2 answers
Postgresql float data type
SQL
0 vote277 views1 answer
User defined variables in sql
SQL
0 vote314 views1 answer
Mysql convert charset
SQL
9 votes282 views4 answers
Oracle get table column names
SQL
0 vote299 views1 answer
Create synonym for dblink in oracle
SQL
0 vote281 views1 answer
Drop procedure sql
SQL

Share