Re: How many rows?

2004-11-15 Thread Gleb Paharenko
= 1 GROUP BY id; I need to know how many rows or how many entries this query returns. I tried to use count and sum. But the result is wrong. I want to be able to make select and know how many rows this query returns. Now, I use mysql_num_rows in php, -- For technical support

Re: How many rows?

2004-11-14 Thread Michael Satterwhite
On Saturday 13 November 2004 06:40 am, Jerry Swanson wrote: This is my query select id, status from sale where user_id = 1 GROUP BY id; I need to know how many rows or how many entries this query returns. I tried to use count and sum. But the result is wrong. I want to be able to make

Re: How many rows?

2004-11-14 Thread Michael Stassen
Your sample query doesn't really make sense, but perhaps you are looking for SQL_CALC_FOUND_ROWS. From the manual, SQL_CALC_FOUND_ROWS (available in MySQL 4.0.0 and up) tells MySQL to calculate how many rows there would be in the result set, disregarding any LIMIT clause. The number of rows

How many rows?

2004-11-13 Thread Jerry Swanson
This is my query select id, status from sale where user_id = 1 GROUP BY id; I need to know how many rows or how many entries this query returns. I tried to use count and sum. But the result is wrong. I want to be able to make select and know how many rows this query returns. Now, I use

Re: How many rows does a table can hold?

2001-03-15 Thread Rino Nucara
I think a good soluthion it is to do a table for every thing and use MERGE table for searching data in all the table (for MERGE see documentation at pag. 271 "MySql table Type" chapter). Il 16:24, mercoled 14 marzo 2001, abdelhamid bettache scrisse: I want to ask you : 1- How

RE: How many rows does a table can hold?

2001-03-15 Thread gavin . wood
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be

How many rows does a table can hold?

2001-03-14 Thread abdelhamid bettache
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more

How many rows does a table can hold?

2001-03-14 Thread abdelhamid bettache
I want to ask you : 1- How many rows does a mysql table can hold? 2- I have to design a database for all universities of my country , Is it better to consider one database for each university or one database for all universities . Note that a query on a table "student" would be more

Re: How many rows does a table can hold?

2001-03-14 Thread Jeremy D. Zawodny
On Wed, Mar 14, 2001 at 07:19:24AM -0800, abdelhamid bettache wrote: I want to ask you : 1- How many rows does a mysql table can hold? Millions. Probably billions. I've heard of someone putting 2 billion rows in a table before (if memory serves). 2- I have to design a database for all