RE: Bug with multi-table DELETE in MySQL 4.0.1

2002-06-03 Thread Sinisa Milivojevic
Leeuw van der, Tim writes: > Hello, > > Thank you very much for your reply! I was hoping that this was indeed fixed > in 4.0.2. I was using 4.0.0 when the bug occurred and upgraded today to > 4.0.1; I will retest the query with 4.0.2 as soon as it's released. > > Apologies btw for not mentionin

bug in multi-table delete in MySQL-4.0.2 ?

2002-05-15 Thread Jocelyn Fournier
Hi, I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if I'm doing something wrong with this query : mysql> DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2 as c WHERE

Re: delete in mysql

2001-04-24 Thread Steve Edberg
At 10:56 AM +0200 4/24/01, Sven Heising wrote: >Hi list When posting help requests, it's always helpful to include the error message you get. You can check quickly this via something like: mysql_query("DELETE FROM $dtable where loginid = '$userto' ") or mysql_error(); One possible

delete in mysql

2001-04-24 Thread Sven Heising
Hi list got a problem againcan't delete : $db=mysql_pconnect($host,$dbuser,$pass) or die($dbfehler); echo "$userto"; mysql_query("use $dbase;"); mysql_query("DELETE FROM $dtable where loginid = '$userto' "); what is wrong with this? thanx in advance sven -