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] - Tell

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 two