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

5 votes183 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote158 views1 answer
Mysql docker image arjun
SQL
0 vote160 views1 answer
Learnxinyminutes sql
SQL
0 vote142 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
15 votes149 views4 answers
Mysql where value is null
SQL
0 vote185 views1 answer
Mysql where sum > 0
SQL
0 vote179 views1 answer
How to subquey to do not load in live database in
SQL
0 vote157 views1 answer
Oracle db timestamp auto add
SQL
0 vote161 views1 answer
Set engine to innodb
SQL
9 votes173 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL