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 vote301 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote296 views2 answers
Wordpress change url in database
SQL
0 vote304 views1 answer
Postgresql combine values in one field
SQL
6 votes293 views4 answers
How to remove unique key in mysql
SQL
0 vote302 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote279 views1 answer
10000000000000000000 am to meters
SQL
0 vote314 views1 answer
Oracle sql add column auto generated value
SQL
0 vote294 views1 answer
Select last N rows mysql
SQL
15 votes299 views1 answer
Mysql int range
SQL
2 votes303 views1 answer
Tsql copy table
SQL