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 vote173 views1 answer
How to run mysql in git bash
SQL
0 vote170 views1 answer
Sql stored procedure update if parameter is not null
SQL
-1 vote154 views1 answer
How to format tables in sqlplus
SQL
13 votes170 views2 answers
Get date from now() mysql
SQL
0 vote177 views1 answer
Enable sql server full text indexing
SQL
0 vote214 views1 answer
Sql to excel pgadmin
SQL
0 vote196 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote189 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes161 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote180 views2 answers
Timing sql queries
SQL