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 vote229 views1 answer
Sub blocks in sql
SQL
3 votes233 views3 answers
How to add month in update sql
SQL
1 vote246 views1 answer
Wordpress change http to https phpmyadmin
SQL
6 votes238 views4 answers
Mysql group by month
SQL
0 vote238 views2 answers
Sql update multiple tables
SQL
0 vote242 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes225 views1 answer
Select nextval from sequence sql
SQL
0 vote244 views1 answer
Sql shell psql cannot enter password
SQL
0 vote222 views1 answer
Take sql dump in to file
SQL
3 votes245 views1 answer
Null sql
SQL