/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

1 vote355 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote275 views2 answers
Mysql between
SQL
1 vote277 views5 answers
What is in operator in sql
SQL
0 vote286 views3 answers
Run sql command line
SQL
0 vote244 views1 answer
Describe in sqlite3
SQL
0 vote258 views1 answer
H2 auto increment and unique
SQL
1 vote268 views1 answer
Drop df constraint sql server
SQL
0 vote251 views1 answer
Sqlserver now
SQL
0 vote267 views1 answer
Join creating duplicate columns sqllite
SQL
3 votes341 views1 answer
Sql select second max
SQL

Share