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 vote185 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
21 votes185 views4 answers
Oracle add column
SQL
1 vote180 views1 answer
Sql in array query
SQL
-1 vote165 views1 answer
Sql getdate date only
SQL
0 vote211 views1 answer
Psql create usr
SQL
3 votes183 views1 answer
RENAME table pl sql
SQL
1 vote179 views1 answer
Media sql
SQL
8 votes183 views1 answer
Oracle search code in packages
SQL
5 votes177 views1 answer
Postgresql functions
SQL
1 vote201 views1 answer
Insert pg result of select
SQL