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 vote205 views1 answer
How to check replication lag in mySQL
SQL
0 vote215 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote216 views1 answer
Update top 100 order by sql server
SQL
1 vote218 views1 answer
Install postgresql on raspberry pi
SQL
3 votes222 views2 answers
MySQL query to get column names
SQL
0 vote172 views1 answer
Deleted table in sql trigger
SQL
0 vote204 views1 answer
Select only one row sql
SQL
-1 vote235 views1 answer
Phinehas Psalm 106
SQL
0 vote241 views1 answer
Remove mysql from centos 7
SQL
-2 votes217 views1 answer
Mysql see users and passwords
SQL