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 vote143 views2 answers
2nd max salary query in sql
SQL
1 vote147 views1 answer
Liquibase alter column type / length
SQL
1 vote136 views1 answer
Adding a default constraint to an existing column in sql
SQL
5 votes140 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote144 views1 answer
Drush run sql select
SQL
1 vote125 views1 answer
Sql server 2012 query history
SQL
1 vote189 views1 answer
Postgres set sequence value to max id
SQL
0 vote151 views1 answer
Xamarin sql lite create table if not exist
SQL
12 votes166 views6 answers
How to install sqlite3 in python
SQL
1 vote158 views1 answer
Nvl postgres
SQL