PHWinfo - Afficher un message

20/12/2007, 17h36

> -----Original Message-----
> From: Jay Pipes [mailto:jay@mysql.com]
> Sent: Thursday, December 20, 2007 11:25 AM
> To: Jerry Schwartz
> Cc: mysql@lists.mysql.com
> Subject: Re: Forbidden subquery
>
> No problem. I hope by now you figured out I made a typo...

The
> WHERE in the DELETE should be prod_price_chg_flag='O', not ="X"

>
[JS] Actually, I didn't look at your solution that closely because in the
meantime my problem got a lot more complicated. I'm going to have to match
on more than one field, so I won't be able to delete all of the "O" records.
I'm going to have to match on a varchar field as well, and do manual cleanup
of any typos.

Your temp-table solution is still going to be at the heart of my work.

20/12/2007, 17h36	#8
Jerry Schwartz Messages: n/a Hébergeur:	RE: Forbidden subquery > -----Original Message----- > From: Jay Pipes [mailto:jay@mysql.com] > Sent: Thursday, December 20, 2007 11:25 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Forbidden subquery > > No problem. I hope by now you figured out I made a typo... The > WHERE in the DELETE should be prod_price_chg_flag='O', not ="X" > [JS] Actually, I didn't look at your solution that closely because in the meantime my problem got a lot more complicated. I'm going to have to match on more than one field, so I won't be able to delete all of the "O" records. I'm going to have to match on a varchar field as well, and do manual cleanup of any typos. Your temp-table solution is still going to be at the heart of my work.