/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

25 votes190 views5 answers
Uninstall mysql ubuntu
SQL
1 vote193 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote202 views1 answer
Insert output identity
SQL
2 votes233 views2 answers
Postgres set user as superuser
SQL
0 vote186 views1 answer
Sql server isnull function nor working count
SQL
0 vote186 views1 answer
Mysql check datetime equals date
SQL
0 vote176 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
0 vote173 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote162 views1 answer
Sql random decimal
SQL
0 vote182 views1 answer
Drop unique
SQL

Share