Turns out to be 4.1.7
This suggestion fixed my query, thanks.
I'd tried that approach yesterday, but it was on an older
version of MySQL (on our non-production server; I wasn't paying attention
to the versions of MySQL betw. our test and production servers) - so my
previous attempts with this syn
Did you upgrade to 4.0.17 or 4.1.7? In 4.1, you have to use the alias
between FROM and USING:
DELETE FROM rls USING rsrc_linx_specialty rls,...
This is documented at the bottom of the manual page you referenced.
Michael
[EMAIL PROTECTED] wrote:
I had a working query that suddenly doesn't work
I had a working query that suddenly doesn't work anymore.
It follows the syntax found in the documentation at
http://dev.mysql.com/doc/mysql/en/DELETE.html
specifically,
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;
my query is:
DELETE FROM rsrc_linx_specialty USING rsrc_
s Lebron" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Wednesday, October 29, 2003 20:05
Subject: Deleting from multiple tables
> I am working on some database tables to handle messages on an intranet.
> One table looks like this
> msg_id | s
I am working on some database tables to handle messages on an intranet.
One table looks like this
msg_id | subject | message | date
there is another table used to track senders and recipients that looks like
this
msg_id | sender_id | recipient_id |
Now what I would like to do is delete any
- Original Message -
From: "Steve Buehler" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 8:45 PM
Subject: Deleting from multiple tables
> I am using MySQL with a PHP front end. Is there a better way to delete
> f
> [snip]
> I am using MySQL with a PHP front end. Is there a better way to delete
> from multiple tables than the following?
> $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
> $result=mysql_query("DELETE FROM conflicts WHERE team_id =
> '$team_id'");
> $resu
At 03:34 PM 5/23/2002 -0400, Keith C. Ivey wrote:
>On 23 May 2002, at 12:48, Steve Buehler wrote:
>
> > I am using MySQL with a PHP front end. Is there a better way to delete
> > from multiple tables than the following?
> > $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
On 23 May 2002, at 12:48, Steve Buehler wrote:
> I am using MySQL with a PHP front end. Is there a better way to delete
> from multiple tables than the following?
> $result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
> $result=mysql_query("DELETE FROM conflicts WHERE
[snip]
I am using MySQL with a PHP front end. Is there a better way to delete
from multiple tables than the following?
$result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
$result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'");
$result=mysql
I am using MySQL with a PHP front end. Is there a better way to delete
from multiple tables than the following?
$result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
$result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'");
$result=mysql_query
I am using MySQL with a PHP front end. Is there a better way to delete
from multiple tables than the following?
$result=mysql_query("DELETE FROM team WHERE team_id = '$team_id'");
$result=mysql_query("DELETE FROM conflicts WHERE team_id = '$team_id'");
$result=mysql_query
12 matches
Mail list logo