mysql获取自增id方法总结

SELECT TABLE_ROWS FROM information_schema.tables WHERE table_name='game' AND table_schema = DATABASE();

$sql="show table status where name ='members'";

$query=mysql_query($sql);

$row = mysql_fetch_array($query);

$curid = $row['Auto_increment'];

?>

1. select max(id) from tablename

2.SELECT LAST_INSERT_ID() 函数