/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

15 votes342 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote373 views1 answer
Normalization in database
SQL
5 votes368 views1 answer
Mysql created at yesterdau
SQL
0 vote373 views1 answer
Sql query tags
SQL
1 vote319 views1 answer
Reutrn string after character sql
SQL
0 vote327 views1 answer
Create table employees oracle
SQL
1 vote396 views1 answer
Last 24 HOUR data in mysql
SQL
2 votes346 views1 answer
Select * from table where name like
SQL
2 votes370 views5 answers
Eloquest how to select one specific column in database
SQL
2 votes385 views2 answers
How to add not null constraint in sql
SQL

Share