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

-1 vote141 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote163 views1 answer
Pgadmin save data greyed out
SQL
11 votes192 views2 answers
You are using safe update mode
SQL
1 vote126 views1 answer
Floor function in sql oracle
SQL
11 votes149 views2 answers
Safe mode off mysql
SQL
60 votes333 views6 answers
Add column in sql
SQL
3 votes164 views5 answers
Duplicate table sql
SQL
0 vote146 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote187 views1 answer
Parent and child link in mysql
SQL
2 votes207 views2 answers
How to DROP a table in mysql
SQL