/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 vote162 views1 answer
Oracle stop
SQL
0 vote136 views2 answers
Add new column after in sql
SQL
0 vote167 views1 answer
How to close external sql connection in laravel
SQL
3 votes146 views4 answers
Ubuntu stop mysql
SQL
0 vote151 views1 answer
Dump only data
SQL
0 vote149 views1 answer
Oracle call a function in a insert statement
SQL
8 votes138 views2 answers
Phpmyadmin password
SQL
4 votes150 views2 answers
Show all database inside postgresql
SQL
0 vote147 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote149 views1 answer
Change schema of all tables postgres
SQL

Share