deleting old records from table without subquery

Hi, I'm having problems trying to construct a delete query from a table. Below is a scaled down version of the table host userdateid - mars john 27-6 1 pluto dave 27-6 2 venus jane 27-6 3 mars john 28-6 4 saturn

make errors on Solaris 9X86 for mysql 4.0.12

ne any c programming. It keeps on falling over when it tries to compile the 'strings' directory... Has anyone else had any compilation issues on X86 or know how to fix it? I'm using gcc 3.2.2 make 3.8.0... I include the output from the failed attempt. thanks in advance... Ruper

make errors on Solaris 9X86 for mysql 4.0.12

ne any c programming. It keeps on falling over when it tries to compile the 'strings' directory... Has anyone else had any compilation issues on X86 or know how to fix it? I'm using gcc 3.2.2 make 3.8.0... I include the output from the failed attempt. thanks in advance... Ruper

MySQL for Netware

, the access time is much slower on Netware than on Windows. Netware = 1.22sec MS = 025sec Is any Netware Settings neccessary with regard to running MySQL? Will appreciate any help ... Thank you! Rupert Open Sesame!: sql, query

Re: Load Data only loads 1 record

ENCLOSED BY '\"' ESCAPED BY '\\' LINES TERMINATED BY '\r' Changing the end to TERMINATED BY '\n' cures the problem - or vice versa, if you see what I mean. Hope that rather poor explanation helps! Rupert