/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

0 vote212 views1 answer
Inner joint
SQL
1 vote222 views1 answer
Get last week data in mysql
SQL
0 vote236 views1 answer
Postgresql port 5432 not open
SQL
1 vote206 views1 answer
Using SQL in rails migration
SQL
1 vote183 views2 answers
Delete auto increment mysql
SQL
2 votes171 views1 answer
Sql float to int
SQL
-1 vote222 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote213 views2 answers
Sql left characters
SQL
0 vote224 views1 answer
Mysql workbench view
SQL
1 vote206 views1 answer
Mysql find tables with column name
SQL

Share