/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 vote251 views1 answer
Convert multiple columns to ROws in sql server
SQL
2 votes174 views2 answers
Mysql all columns
SQL
0 vote192 views1 answer
Join in update query in mysql
SQL
0 vote196 views1 answer
Import excel to sql
SQL
13 votes194 views4 answers
What is sql
SQL
0 vote197 views1 answer
Sql doesn't contain
SQL
11 votes190 views2 answers
Turn off safe mode mysql
SQL
4 votes182 views1 answer
Sql delete where in select
SQL
6 votes243 views2 answers
Return columns from table sql
SQL
2 votes175 views2 answers
Oracle create table if not exists
SQL

Share