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

2 votes188 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote210 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote196 views1 answer
Sql row number in result set
SQL
3 votes201 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote196 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
1 vote191 views1 answer
Sql group by error
SQL
0 vote190 views1 answer
Oracle string substitution
SQL
0 vote213 views1 answer
Sql remove last 2 digit
SQL
0 vote227 views1 answer
Oracle winter time change
SQL
0 vote217 views2 answers
Cambiar nombre tabla mysql
SQL