Re: Problem with ordering select

2002-03-18 Thread Sammy Lau
Michal, > /dev/hda8 256667256667 0 100% / looks like your root partition is full. 'show variables' tells you where Mysql is putting the temp table for your "order by" query. i believe it is sitting under your root partition. -- Sammy Lau mailto: [EMAIL PROTECTED] - Te

Problem with ordering select

2002-03-17 Thread Michal Ludwiczak
Hello! I'm not a very experienced SQL user and I cam accross a problem. But first I will explain the database structure. There are two tables: "mieszkania" whis contains some fields, one of them being "miasto_id" of int type, and the other called "miasta" with the same firld name joining these tw