mysql FUNCTION CONCAT does not exist
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
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.