Mysql Query Problem!

[Kart20]

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 coulmns 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 ?

Thanks,
Karthik

[neh]

I'm guessing you're exceeding the max_allowed_packet setting as its defined in your mysql install .. (the max packet size it can receive or send basically) ..

presumably this server variable can be amened with a SET max_allowed_packet = n sql command 🙂 (nb .. is set in bytes .. so mine is curently 1048576 (1 mb) which I guess must be default ..

good luck 🙂