Home ›
Fastest way to check if anything is in a MySQL tableFastest way to check if anything is in a MySQL table
Submitted by Benjamin Melançon on December 18, 2007 - 7:54pm
Searched words:
mysql fastest way to check for rows in table
mysql is table empty
http://forums.mysql.com/read.php?101,50600,50853#msg-50853
Vail wrote:
> When it checks to see if the
> group exists, however, and the table is empty, it
> always returns an error, which disables the script
> that calls the function.Why not doing a simple
select count(*) from groups
?
This tells you directly how many groups you have and will always return a valid value.
Mike
Mike Lischke, Software Engineer GUI
MySQL AB, www.mysql.com
Resolution
More like this
- Fastest way to get just one result from a database table in Drupal
- Select rows in a MySQL table that have no corresponding rows in another table using IS NULL
- Combining one-to-one mysql tables into a single table
- MySQL Binary Logs of Death
- MySQL user at any host doesn't work, needs localhost in some local personal computer development environments
Comments
Long thread on count speed
http://www.mysqlperformanceblog.com/2007/04/10/count-vs-countcol/
Faster way
SELECT 1 FROM
tableLIMIT 1;This is imho the fastest way to find out, if the table is empty, no counting, just stop at first match - if it finds a line, it returns a constant of 1, otherwise, empty result.
Cool, thanks!
Didn't know you could just do "SELECT 1" like that. Very nice!
Post new comment