Update and Cast marked as error
Hallo
I'm having problems with this query
update wp_posts
SET guid = wo.option_value + '/' + CAST(wp.ID AS char(20))
from wp_posts wp, wp_options wo
where wo.option_name = 'siteurl';
MySQL Workbench is marking in red the "from"
Actually, I'd need a conversion as varchar but in that case the varchar would be marked in red.
In any case, I'm having a "syntax error".
Could you point me in any direction please? thank you!
Subject
Written By
Posted
Update and Cast marked as error
April 10, 2013 01:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.