/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 vote233 views1 answer
Sql express database size limit
SQL
0 vote223 views1 answer
Compare subqueries oracle
SQL
1 vote229 views1 answer
Postgres see sequence current state
SQL
3 votes186 views1 answer
Sql replace character in string in all records
SQL
0 vote223 views1 answer
Sql sum if
SQL
2 votes185 views1 answer
Sql select min value from multiple columns
SQL
0 vote197 views1 answer
Postgresql create table with boolean column
SQL
0 vote243 views1 answer
Modifier une valeur sql
SQL
2 votes208 views1 answer
Oracle insert or update
SQL
2 votes214 views3 answers
Copy data from one table column to another table column in sql
SQL

Share