Hi,
I am using a query that returns around 13000 records from a mysql database.
The problem i am facing is, if i want to add any more columns in the query,
mysql does not return all the records. It returns only around 8000 records.
I somehow feel that it has something to do with the number of bytes returned
by a query. Is this the case ? How do i change the same ? Is there any mysql
setting?
I work on mysql 3.23.51 on WinNT.
Thanks,
Karthik
P.S. - The Queries are as under -
This is the query i run first -
select user.userid, user.name, plan.duration, plan.hour, plan.minute,
plan.status, plan.date, project.projectname,project.projectid from user,
plan, project where user.userid = plan.userid and project.projectid =
plan.projectid and plan.date >= '2002-8-13' and plan.date<='2002-12-31' and
user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour
The abover returns around 13000 records
When i run the below query it only returns 8000 odd records. The only change
is adding of user.designation colum in the query.
select user.userid, user.name, user.designation, plan.duration, plan.hour,
plan.minute, plan.status, plan.date, project.projectname,project.projectid
from user, plan, project where user.userid = plan.userid and
project.projectid = plan.projectid and plan.date >= '2002-8-13' and
plan.date<='2002-12-31' and user.userid in
('abhijitg','anand','anil_m','gopal','gouri','leena','maheshg','nitin','pras
ad','ramesh','rohit','samir_more','sarita','sunilp','uday','vijay','shubhada
','abhilash','aditi','ajayg','deepali','denise','nilanjana','nilashree','pra
jakta_p','priya','savio','shilpak','sindhu','usha','valiollah','geetanjalih'
,'saroop') group by plan.userid,plan.date,plan.hour
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
