/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

3 votes341 views1 answer
Oracle list dates without weekends
SQL
0 vote331 views1 answer
Change magento database url usimg musql
SQL
0 vote316 views1 answer
Codeigniter dbforge add index
SQL
0 vote323 views1 answer
Sql select merge multiple values
SQL
1 vote388 views1 answer
OSError: mysql_config not found
SQL
0 vote323 views1 answer
Alter owner in PostgreSQL
SQL
0 vote327 views1 answer
Sql comand for removing data from table
SQL
0 vote327 views1 answer
Datagrip go to line
SQL
1 vote309 views1 answer
Set statiscis on in sql server
SQL
0 vote317 views1 answer
Laravel eloquent get generated sql
SQL

Share