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 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 >
Explain only works with tables and SELECT queries: http://dev.mysql.com/doc/refman/4.1/en/explain.html -- Pat Adams Digital Darkness Promotions Dallas Music Wiki http://digitaldarkness.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
