Mysql获取id最大值、表的记录总数等相关问题的方法汇总

select max(id) from yourtable;

show table status like “表名”;

$get_table_status_sql = "SHOW TABLE STATUS LIKE '表名'";
$result = mysql_query($get_table_status_sql);
$table_status = mysql_fetch_array($result);
echo $table_status['Auto_increment']; // 这个就是自增值

select max(id) from testnotnull;

select count(*) from table;

select count(id) from table;

SELECT SQL_CALC_FOUND_ROWS * FROM table_name;
SELECT FOUND_ROWS();

SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]

SHOW TABLE STATUS FROM cpdlt LIKE 'lehecai_1202';