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 vote215 views1 answer
Update sql join multiple tables
SQL
1 vote285 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote248 views1 answer
Myswql show full processlist
SQL
0 vote285 views1 answer
Oracle webcenter content search enginer
SQL
0 vote311 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
1 vote257 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote259 views1 answer
Select from describe sql
SQL
8 votes229 views8 answers
Second highest salary in mysql
SQL
0 vote275 views1 answer
Mysql aspas simples
SQL
1 vote265 views1 answer
Error code 1175 mysql fix
SQL