MySQL Forums
Forum List  »  Newbie

Update and Cast marked as error
Posted by: Raffaele Turra
Date: April 10, 2013 01:26PM

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!

Options: ReplyQuote


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.