Re: how to count all records in MySQL table?

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

  • Next message: Luis I. Gomez: "How can I push a VFP Table to a SQL Server." 
    Date: Wed, 23 Feb 2005 08:22:38 -0500

    http://dev.mysql.com/doc/mysql/en/select.html

    The Count() exists in MySQL syntax, but it will have to access the table,
    but the resulting cursor will return one record. You cannot store that in a
    variable, you need to read the value in the Count field.

    "winvis" <info@bah.nl> wrote in message
    news:e5a44a8fcdcda7afa3b36d49a378385f@localhost.talkaboutsoftware.com...
    > Mike,
    >
    > Is there any alternative? I just need a variable with the total number of
    > records in my MySQL table. That's all...
    >
    > Regards, Johan
    >

  • Next message: Luis I. Gomez: "How can I push a VFP Table to a SQL Server."