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

36 votes416 views6 answers
Change column data type sql
SQL
14 votes375 views3 answers
How to add default constraint in mysql
SQL
0 vote400 views1 answer
Mariadb create index if not exists
SQL
0 vote316 views1 answer
Import sql mysql ubuntu
SQL
22 votes463 views4 answers
Mysql format date
SQL
1 vote408 views1 answer
Oracle transaction rollback not working
SQL
0 vote345 views1 answer
Sql server port 1434
SQL
0 vote347 views1 answer
How to get data between a last week in mysql
SQL
22 votes385 views3 answers
Year format in date mysql
SQL
0 vote349 views1 answer
Output table plsql
SQL