获取表行数的最有效方法

Most efficient way to get table row count(获取表行数的最有效方法)

本文介绍了获取表行数的最有效方法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我目前有一个超过 600 万行的数据库,并且还在不断增加.我目前做 SELECT COUNT(id) FROM table;为了向我的用户显示数字,但数据库越来越大,除了能够显示数字外,我不需要存储所有这些行.有没有办法选择要显示的 auto_increment 值,以便我可以清除数据库中的大部分行?使用 LAST_INSERT_ID() 似乎不起作用.

I currently have a database with over 6 million rows and growing. I currently do SELECT COUNT(id) FROM table; in order to display the number to my users, but the database is getting large and I have no need to store all of those rows except to be able to show the number. Is there a way to select the auto_increment value to display so that I can clear out most of the rows in the database? Using LAST_INSERT_ID() doesn't seem to work.

推荐答案

如果只是获取记录数(行),我建议使用:

If it's only about getting the number of records (rows) I'd suggest using:

SELECT TABLE_ROWS
FROM information_schema.tables 
WHERE table_name='the_table_you_want' -- Can end here if only 1 DB 
  AND table_schema = DATABASE();      -- See comment below if > 1 DB

(至少对于 MySQL)代替.

(at least for MySQL) instead.

这篇关于获取表行数的最有效方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:获取表行数的最有效方法

基础教程推荐