Re: [mysql] Counting rows

2003-02-11 Thread Ahmed S K Anis
show table status: check out the columns names you will get as idea as to how info it gives. >>> olinux <[EMAIL PROTECTED]> Wednesday, February 12, 2003 12:21:16 PM >>> SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's sup

Re: [mysql] Counting rows

2003-02-11 Thread olinux
SELECT count(*) FROM table WHERE whatever olinux --- Tim Johnson <[EMAIL PROTECTED]> wrote: > Hello All: > Let's suppose I want to count the rows in set > for a match > to a value in a column. I don't need to read the > selection > set, I just need to know the number of matches. > > What is

[mysql] Counting rows

2003-02-10 Thread Tim Johnson
Hello All: Let's suppose I want to count the rows in set for a match to a value in a column. I don't need to read the selection set, I just need to know the number of matches. What is the quickest, most efficient way to do this in mysql? TIA -- Tim Johnson <[EMAIL PROTECTED]> http://www