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

37 votes368 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote334 views1 answer
Dump only schema
SQL
0 vote434 views1 answer
Python get backup of sql
SQL
0 vote339 views1 answer
Mysql:5.6 syntax create table
SQL
1 vote351 views1 answer
Funzioni plsql
SQL
0 vote357 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
7 votes358 views1 answer
Connect mysql docker
SQL
0 vote386 views2 answers
Pop sql insert value into
SQL
4 votes368 views3 answers
Copy table postgres
SQL
3 votes367 views2 answers
Mysql config user password
SQL