sql - MySQL: ERROR 1054 (42S22): Unknown column in 'where clause' -
I am making some changes to a WordPress database. I need to replace UPL on UP-post table with ULL, which is a URL coming from another table called EBBRL. The details of the table are as follows:
wp_posts: I want to have field types for two fields:
ID -> bigint (20) unsigned
guid -> varchar (255)
and the table where I have data I need to export to wp_posts:
ebdurls:
Title -> varchar (255)
url -> varchar (255)
EBIDID -> Bilent (20) unsigned
Everything looks right, but when If I apply the next query then I get an error that I can not really get. I have tried to quote fields, tables etc. ... everywhere, but no luck.
mysql> update wp_posts set wp_posts.guid = ebdurls.url where wp_posts.id = ebdurls.ebdid;
Error 1054 (42 s 22): 'where segment' in unknown column 'ebdurls.ebdid'
Where's the fault?
You have not specified whether ebdurls is, add a query to your query:
UPDATE wp_posts, Ebdurls SET wp_posts.guid = ebdurls.url WHERE wp_posts.id = ebdurls.ebdid;
Edit: The bill was right, now the format has been fixed.
Comments
Post a Comment