/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 vote202 views1 answer
Mysql pretty date format
SQL
0 vote186 views1 answer
RowDataPacket
SQL
0 vote186 views1 answer
Report in database
SQL
0 vote194 views1 answer
Get all employees if name ends with in sql
SQL
0 vote190 views2 answers
Sql use not in
SQL
9 votes216 views3 answers
Where clause sql
SQL
0 vote219 views1 answer
Query to insert image
SQL
0 vote292 views1 answer
Example database query
SQL
1 vote204 views2 answers
Oracle create synonym
SQL
0 vote194 views1 answer
Group_concat only returns one row
SQL

Share