= 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
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
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
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
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
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
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
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
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