/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 vote183 views2 answers
Cambiar nombre tabla mysql
SQL
5 votes224 views1 answer
How to use rank function in sql
SQL
2 votes200 views1 answer
Oracle to_char number format percentage
SQL
0 vote199 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote222 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
5 votes184 views2 answers
Sql conn
SQL
3 votes184 views2 answers
Oracle synonym
SQL
0 vote185 views1 answer
Wordpress database query change url
SQL
1 vote189 views1 answer
Temp table vs variable table in sql server
SQL
9 votes181 views4 answers
How to remove duplicate in sql
SQL

Share