MySQL Forums
Forum List  »  Newbie

mysql FUNCTION CONCAT does not exist
Posted by: jeorg calimet
Date: October 28, 2010 01:57AM

I am on mysql 5.1

if I do SELECT CONCAT (a,b) FROM tb it works
If I do

UPDATE jos_vm_product_files pf
INNER JOIN jos_vm_product_imgs pi
ON pf.file_product_id = pi.product_id
SET pf.file_title= concat ( replace(pi.cat_fr , '_', ' '),' ', replace(pi.product_name, '_', ' ') );

I get FUNCTION mydatabase.CONCAT does not exist

it works perfectly on my localhost

any idea ?

thank you

Options: ReplyQuote


Subject
Written By
Posted
mysql FUNCTION CONCAT does not exist
October 28, 2010 01:57AM


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.