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
>



Relevant Pages

  • Re: Some free utilities for Java, with Hebrew support.
    ... protocol and server and add "extensions" to make their product more ... Provided you want to remain compatible with the "stock" MySQL ... the server you were using to support something ... client libraries don't support or in changing the protocol to break ...
    (comp.lang.java.programmer)
  • Re: SQL difference - mySQL and MS SQL
    ... MySQL is pretty far behind most of the other database ... They just added support for things such as stored ... I have never seen such a reference, and it highly depends on the version ... version 4 is nowhere near Microsoft SQL Server (in any version I've ...
    (microsoft.public.sqlserver.connect)
  • Mambo 4.0.14 Stable Bugs
    ... "into outfile" feature of MySQL. ... Because older versions don't support UNION function. ... In this case, username, md5() hashed password and email address of user ...
    (Bugtraq)
  • Re: Few Question About SSH
    ... options (eg enabling sparcv9 support on those systems) without building ... MYSQL server, i tried with pam-mysql and i changed all of pam ... completly from mysql database. ... Good judgement comes with experience. ...
    (SSH)
  • Re: Server Database - MySQL?
    ... Now that MySQL has reached version 5, it finally has support for transactions, triggers, stored procedures, and views. ... Postgres and Firebird have supported all those things for a while, so you might find better third-party support for those features with those databases than you would with MySQL. ... When I first started doing database stuff with Delphi, my only experience had been with Access and MySQL. ...
    (comp.lang.pascal.delphi.misc)