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

17 votes103 views3 answers
Cast in sql server
SQL
2 votes111 views2 answers
Mysql show table column comments sql
SQL
3 votes105 views3 answers
Create table in microsoft sql server
SQL
1 vote100 views3 answers
Getdate function in postgresql
SQL
0 vote109 views1 answer
Copied text from internet not inserting in mysql
SQL
0 vote117 views1 answer
Sql query to get column names and data types in sql server
SQL
2 votes92 views2 answers
Mysql limit
SQL
2 votes96 views1 answer
Date_format for time sql
SQL
0 vote115 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote102 views1 answer
Check psql validity function
SQL