On Wed, Jul 02, 2003 at 10:57:18AM -0500, Roy W wrote:
> Is there a simple MySQL command that will give a Row Count (# of records)
> WITHOUT running a select (huge database)
If it's a MyISAM table, just run a SELECT COUNT(*) FROM table_name.
It's really efficient. Try it. :-)
--
Jeremy D. Zawodn
If your table is MyISAM, then
SELECT COUNT(*) FROM tablename
Will return a rowcount without a major performance hit as the rowcount
is stored and a table scan is not needed.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Roy W [mailto:[EMAIL PROTECTED]
> Sent: Wed
>> Here's a nice MySQL simple returning records query question!
>>
>> I want to return a staement saying 'number of records shave been
>> found'
> for your
>> selection.
>>
>> so presumably this is a simple row count based on the the returning
> recordset?
>>
>> Andrew
>
> Either with PHP or C you
> Here's a nice MySQL simple returning records query question!
>
> I want to return a staement saying 'number of records shave been found'
for your
> selection.
>
> so presumably this is a simple row count based on the the returning
recordset?
>
> Andrew
Either with PHP or C you can use mysql_num_
error
let me know and I will send it to you.
Thanks again
- Original Message -
From: "Shyamal Banerjee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:29 AM
Subject: Re: Count Rows in two tables
> If you know the primary keys of
;Rick Baranowski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 8:39 AM
Subject: Re: Count Rows in two tables
> Please forgive me I am new to mySQL, could you give me an example of how I
> would do this? The two tables are users
Please forgive me I am new to mySQL, could you give me an example of how I
would do this? The two tables are users and staff
Thanks
Rick
- Original Message -
From: "Murad Nayal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, November 12, 2002 6:58 PM
S
Ah, yes - sorry
Alan
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:murad@;godel.bioc.columbia.edu]On Behalf Of Murad Nayal
> Sent: Wednesday, 13 November 2002 12:58
> Cc: [EMAIL PROTECTED]
> Subject: Re: Count Rows in two tables
>
>
>
> Ala
Alan McDonald wrote:
>
> You can't count the join?
> Alan
if you count the (unqualified) join you'll end up with the product of
the two table counts.
Murad
>
> > -Original Message-
> > From: Rick Baranowski [mailto:rickb@;baranconsulting.com]
> > Sent: Wednesday, 13 November 2002 12:
Does it have to be in a single query. You could use a Union query and
then total the results in your program.
Select Count(Field1)
>From Table1
Union Select Count(Field1)
>From Table2;
>>> "Rick Baranowski" <[EMAIL PROTECTED]> 11/12/02 5:10:14 PM
>>>
Hello all,
Does anybody have a SQL string
On 11/12/02 5:36 PM, "Alan McDonald" <[EMAIL PROTECTED]> wrote:
> You can't count the join?
> Alan
>>
>> Hello all,
>>
>> Does anybody have a SQL string to count the rows in two different
>> tables and
>> give you a total number of rows? I have been trying to find an
>> answer for a
>> couple of
You can't count the join?
Alan
> -Original Message-
> From: Rick Baranowski [mailto:rickb@;baranconsulting.com]
> Sent: Wednesday, 13 November 2002 12:10
> To: [EMAIL PROTECTED]
> Subject: Count Rows in two tables
>
>
> Hello all,
>
> Does anybody have a SQL string to count the rows in
12 matches
Mail list logo
