/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

20 votes164 views4 answers
How to find average in sql
SQL
0 vote125 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote175 views1 answer
Selecting from a view SQL
SQL
0 vote118 views1 answer
Create table employees oracle
SQL
0 vote114 views1 answer
Tsql generate rows
SQL
1 vote112 views1 answer
What is int in mysql
SQL
1 vote246 views2 answers
Postgres select from last 3 months
SQL
3 votes127 views1 answer
Oracle drop user
SQL
0 vote134 views1 answer
Query by column for substring sql
SQL
49 votes215 views6 answers
Install mysql ubuntu
SQL

Share