List:General Discussion« Previous MessageNext Message »
From:Mikhail Berman Date:November 29 2006 9:21pm
Subject:RE: Any explanation for this, please
View as plain text  
Thank you 


Mikhail Berman

-----Original Message-----
From: Paul DuBois [mailto:paul@stripped] 
Sent: Wednesday, November 29, 2006 3:30 PM
To: Mikhail Berman; mysql@stripped
Subject: RE: Any explanation for this, please

At 14:41 -0500 11/29/06, Mikhail Berman wrote:
>Thank you, Sir.
>
>So, there is no way to plan update query?
>

Not except in the sense of getting a plan for a similar SELECT
statement.


>Regards,
>
>Mikhail Berman
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Wednesday, November 29, 2006 2:37 PM
>To: Mikhail Berman; mysql@stripped
>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 similar SELECT.
>
>
>>
>>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_shares_outstanding_market_cap = t.MarketValue; ERROR 1064
>>(42000): You have an error in your SQL syntax; check the manual that 
>>corresponds to your MySQL server version for the right syntax to use 
>>near 'update COMPANY_NUMBERS_tmp_Mikhail c join tmp_HEMSCOTT_MKTVALUES

>>t on c.ticker =' at line 1
>>
>>2.
>>
>>Actual execution of the update statement goes through, no problem
>>
>>mysql> update COMPANY_NUMBERS_tmp_Mikhail c join 
>>mysql> tmp_HEMSCOTT_MKTVALUES
>>t on c.ticker = t.TickerSymbol and t.InterimEndingDate =
>>replace(left(c.date_qtr,7),'-','/')
>>set c.total_shares_outstanding_market_cap = t.MarketValue; Query OK,
>>157551 rows affected (4 min 22.81 sec) Rows matched: 162999  Changed:
>>157551  Warnings: 0
>>
>>Regards,
>>
>>Mikhail Berman
>>
>
>
>--
>Paul DuBois, MySQL Documentation Team
>Madison, Wisconsin, USA
>MySQL AB, www.mysql.com
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql To unsubscribe:
>http://lists.mysql.com/mysql?unsub=1


-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Any explanation for this, pleaseMikhail Berman29 Nov
  • Re: Any explanation for this, pleasePaul DuBois29 Nov
    • RE: Any explanation for this, pleaseMikhail Berman29 Nov
      • RE: Any explanation for this, pleasePaul DuBois29 Nov
        • RE: Any explanation for this, pleaseMikhail Berman29 Nov
  • Re: Any explanation for this, pleasePat Adams29 Nov