Re: Count Rows?

2003-07-04 Thread Jeremy Zawodny
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. Zawodny

RE: Count Rows?

2003-07-02 Thread Mike Hillyer
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:

Re: count rows

2003-02-28 Thread Roman Sanchez
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_rows()

Re: count rows

2003-02-28 Thread William R. Mussatto
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

Re: Count Rows in two tables

2002-11-13 Thread Shyamal Banerjee
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 and staff Thanks Rick - Original Message

Re: Count Rows in two tables

2002-11-13 Thread Rick Baranowski
the 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 the two tables, it may be done

RE: Count Rows in two tables

2002-11-12 Thread Alan McDonald
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 two

Re: Count Rows in two tables

2002-11-12 Thread R. Hannes Niedner
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 days and seems like

Re: Count Rows in two tables

2002-11-12 Thread Ed Reed
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 to count

Re: Count Rows in two tables

2002-11-12 Thread Murad Nayal
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:10 To:

RE: Count Rows in two tables

2002-11-12 Thread Alan McDonald
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 Alan McDonald wrote: You can't count

Re: Count Rows in two tables

2002-11-12 Thread Rick Baranowski
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 Subject: Re: Count Rows