Insert into auto increment mysql

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

Source: stackoverflow.com

Auto_increment mysql

ALTER TABLE User AUTO_INCREMENT = 1;

Insert into auto increment mysql

/* To insert into an auto incrementing field without specifing every column in
the table, you can use the key word default in the place of the auto 
incrementing column*/

INSERT INTO my_table VALUES(default, "test1", 222)
/*VS */
INSERT INTO my_table(name, num) VALUES("test1", 222)
/*Having to type out all of the column names except the auto incrementing one
can be very tedious when you have many columns, just use the keyword defualt
instead and you only have to type it once.

Similar codes

0 vote262 views1 answer
Sql server udf performance
SQL
8 votes268 views1 answer
Database backup in mysql server recovery
SQL
1 vote294 views1 answer
T-sql disable system versioning
SQL
0 vote278 views2 answers
Nosqlbooster query other collection
SQL
2 votes293 views2 answers
Mysql on duplicate key update get value from values
SQL
1 vote276 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote273 views1 answer
Systems sql
SQL
16 votes270 views3 answers
Delete row psql
SQL
1 vote270 views2 answers
Mysql select tables with name like
SQL
0 vote301 views1 answer
SQL server datetime compare
SQL