/SQL/Mysql check auto increment value

Mysql check auto increment value

Mysql set id auto increment

ALTER TABLE users AUTO_INCREMENT=1001;

6

Source: stackoverflow.com

Mysql check auto increment value

SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name';

0

Similar codes

11 votes331 views6 answers
Mysql else if
SQL
1 vote283 views1 answer
Find logged in users mysql
SQL
5 votes299 views1 answer
Oracle columns in all_tables
SQL
2 votes322 views2 answers
Postgres trigger insert into another table
SQL
13 votes317 views2 answers
Sql online compiler
SQL
3 votes319 views1 answer
Oracle function return
SQL
0 vote301 views1 answer
Mysql update from n to 100
SQL
1 vote303 views2 answers
Drop table if exists test
SQL
0 vote304 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote394 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL

Share