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 vote147 views1 answer
Sql create and grant user access to database
SQL
2 votes114 views1 answer
Rails execute sql
SQL
2 votes116 views3 answers
How to pass password mysql command line
SQL
1 vote132 views1 answer
How to put value in variable mysql
SQL
0 vote164 views1 answer
Sql server system messeges
SQL
4 votes108 views1 answer
Oracle session date format
SQL
3 votes114 views1 answer
Uppercase and lowercase in sql
SQL
9 votes138 views3 answers
Sequence postgresql
SQL
1 vote133 views1 answer
Update substring in mysql
SQL
9 votes114 views6 answers
Sql insert into
SQL