/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 vote322 views1 answer
Sql Split string function
SQL
3 votes351 views1 answer
APEX elapsed time
SQL
0 vote338 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote310 views1 answer
Oracle list chain steps
SQL
1 vote336 views1 answer
Moodle query item quiz
SQL
0 vote338 views1 answer
Selecting from a view SQL
SQL
0 vote322 views1 answer
Sql beginning of previous month
SQL
0 vote336 views1 answer
Get create sql of hibernqte entity
SQL
0 vote340 views1 answer
How to insert a uniqueidentifier in sql
SQL
1 vote353 views1 answer
Update from select oracle
SQL

Share