Re: how to count all records in MySQL table?

From: Mike Gagnon (mgagnon23_at_hotmail.com)
Date: 02/23/05


Date: Wed, 23 Feb 2005 06:53:44 -0500

MySQL does not support Count()

"winvis" <info@bah.nl> wrote in message
news:627a37f566d509c7db7ec8c2d2f35320@localhost.talkaboutsoftware.com...
> Hi,
>
> I try to put the total number of records in my MySQL table into a
> variable.
>
> Something like
> public recs
> recs = select count(*) from CVIS
>
> (CVIS is my table)
>
> This results in a syntax error.
>
> What's going wrong?
>
> Johan
>