/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

6 votes198 views3 answers
How to delete table sqlite
SQL
0 vote197 views1 answer
Mysql update table from select on another table
SQL
0 vote212 views1 answer
Oracle drop type
SQL
0 vote195 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote173 views2 answers
Change database postgres
SQL
0 vote200 views1 answer
How to select all fieldsin a soql query
SQL
10 votes201 views4 answers
How to alter table name in mysql
SQL
0 vote203 views1 answer
Mysql last friday of current month
SQL
0 vote184 views1 answer
Psql not found windows
SQL
6 votes194 views2 answers
Where clause in sql
SQL

Share