Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get the next auto_increment value mysql

SHOW TABLE STATUS FROM tablename LIKE Auto_increment
/*or*/
SELECT `auto_increment` FROM INFORMATION_SCHEMA.TABLES
WHERE table_name = 'tablename'
Comment

PREVIOUS NEXT
Code Example
Sql :: postgresql change column type 
Sql :: postgresql truncate cascade restart identity 
Sql :: update part of a string in mysql 
Sql :: sql delete multiple ids 
Sql :: oracle list functions 
Sql :: sql dateadd hours 
Sql :: select users 
Sql :: mysql change root mysql_native_password 
Sql :: mysql interval 1 day 
Sql :: how remove column in mysql 
Sql :: mysql command line connect 
Sql :: primary key reset in SQL database 
Sql :: oracle start job 
Sql :: how to run mysql in git bash 
Sql :: mysql import gzip db 
Sql :: mysql server start 
Sql :: psql view enum values 
Sql :: oracle check table space 
Sql :: command line mysql import 
Sql :: mysql count newlines in field 
Sql :: String concatenation in PostgreSQL 
Sql :: node and mysql like 
Sql :: sqlite3 how to get column names of a table 
Sql :: mysql get count of rows 
Sql :: create email address from first and last name in sql 
Sql :: mac os zsh: command not found: mysql 
Sql :: set boolean flasksql 
Sql :: sql for date greater than 
Sql :: start mysql linux terminal 
Sql :: mssql cursor 
ADD CONTENT
Topic
Content
Source link
Name
4+7 =