Thank you
Mikhail Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 3:30 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: RE: Any explanation for this, please
At 14:41 -0500 11/29/06, Mikhail Berman wrote:
>Thank you,
: Wednesday, November 29, 2006 2:37 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: Any explanation for this, please
At 14:31 -0500 11/29/06, Mikhail Berman wrote:
Dear List,
Could I get an explanation why 1 fails, but 2 works.
Because EXPLAIN is used only with SELECT statements.
Try to use a
Thank you, Sir.
So, there is no way to plan update query?
Regards,
Mikhail Berman
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 2:37 PM
To: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: Any explanation for this, please
At 14
On Wed, 2006-11-29 at 14:31 -0500, Mikhail Berman wrote:
> Dear List,
>
> Could I get an explanation why 1 fails, but 2 works.
>
> 1. Update statement preceded with explain, fails:
>
> explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES
> t on c.ticker = t.TickerSymbol an
At 14:31 -0500 11/29/06, Mikhail Berman wrote:
Dear List,
Could I get an explanation why 1 fails, but 2 works.
Because EXPLAIN is used only with SELECT statements.
Try to use a similar SELECT.
1.
Update statement preceded with explain, fails:
explain update COMPANY_NUMBERS_tmp_Mikhail c
Dear List,
Could I get an explanation why 1 fails, but 2 works.
1.
Update statement preceded with explain, fails:
explain update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES
t on c.ticker = t.TickerSymbol and t.InterimEndingDate =
replace(left(c.date_qtr,7),'-','/') set
c.total