2007-01-18 09:47:43 · 4 answers · asked by WAW 1 in Computers & Internet ➔ Programming & Design
mysql, myisam tables?
select count(*) from table;
quick since it's cached. innodb tables could be inaccurate..would need to know more about what you're using.
2007-01-18 09:55:21 · answer #1 · answered by David 2 · 1⤊ 0⤋
This depends on which database you are using and which version of SQL you are using. Could be rownum, rowcount, describe, or in some versions, the only method is to write a sql statement to calculate it (ex.
SELECT
rows
FROM
sysindexes
WHERE
id = object_id('
AND indid < 2
OR
select count(*) from tabname
2007-01-18 18:11:57 · answer #2 · answered by Carter 3 · 0⤊ 0⤋
SELECT count(*) FROM my_table
I'm pretty sure that's it.
2007-01-18 18:58:12 · answer #3 · answered by wi_guy 2 · 0⤊ 0⤋
Been a while...
COUNT?
2007-01-18 17:52:50 · answer #4 · answered by Jon W 5 · 0⤊ 0⤋