/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

2 votes103 views1 answer
Drop table if exists in postgres
SQL
1 vote106 views1 answer
Spark sql concatenate string and int
SQL
0 vote126 views1 answer
Select count concat string sql server
SQL
0 vote96 views1 answer
Postgres call view
SQL
1 vote115 views2 answers
Sql drop multiple columns if exists
SQL
0 vote103 views1 answer
Cannot pip install mysqlclient
SQL
0 vote119 views1 answer
Sql select sum group by id laravel join
SQL
0 vote135 views1 answer
Restart serial number for postgres
SQL
0 vote100 views1 answer
Procedure excute monthly oracle
SQL
3 votes98 views1 answer
Oracle get trigger ddl
SQL

Share