MySQL get self-Increasing ID method summary

Method One,

The code is as follows	Copy Code
SELECT table_rows from Information_schema.tables WHERE table_name= ' game ' and Table_schema = DATABASE ();

Usage in PHP

PHP code example

The code is as follows	Copy Code
<?php $sql = "Show Table status where name = ' Members '"; $query =mysql_query ($sql); $row = Mysql_fetch_array ($query); $curid = $row [' auto_increment ']; ?>

In addition, you can also use

The code is as follows	Copy Code
1. Select Max (ID) from TableName 2.SELECT last_insert_id () function

To get here is not introduced.