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 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/[EMAIL PROTECTED]