/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

17 votes372 views4 answers
Sort by mysql
SQL
0 vote304 views1 answer
Denied
SQL
0 vote364 views1 answer
Java nosql sort
SQL
0 vote351 views1 answer
Left join in codeigniter query builder
SQL
-1 vote351 views3 answers
Update mongodb version ubuntu
SQL
0 vote366 views1 answer
Sql replace id with name from another table
SQL
0 vote375 views1 answer
Postgres can integer fields be negative
SQL
0 vote350 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote343 views1 answer
What are the aggregate function in sql
SQL
7 votes347 views1 answer
Forge server hosting
SQL

Share