/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 vote137 views1 answer
Psql lst trigger
SQL
0 vote101 views1 answer
Java spring jdbc connect to postgresql
SQL
27 votes156 views6 answers
Set password mysql
SQL
0 vote134 views1 answer
Drop all tables db2
SQL
1 vote147 views1 answer
How to print longest name in sql
SQL
0 vote179 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote142 views1 answer
Delete first row in sql
SQL
1 vote153 views2 answers
Sql now - 1 day
SQL
0 vote125 views1 answer
Trim sql oracle
SQL
0 vote133 views1 answer
Fill up postgres db
SQL

Share