php - MySql - PHP 更新

Question

使用此代码:

$result = mysql_query("
 UPDATE skroutz SET 
 Image_Link=(
   SELECT file_url 
   FROM bonnie_virtuemart_medias 
   INNER JOIN bonnie_virtuemart_product_medias 
   ON bonnie_virtuemart_medias. virtuemart_media_id =bonnie_virtuemart_product_medias. virtuemart_media_id 
   WHERE virtuemart_product_id=Unique_ID LIMIT 1)",$db);

我得到了以下形式的路径/images/stories/virtuemart/product/1200x1000.gif

从我的数据库中已存在的表中获取它，并使用 UPDATE 传输到另一个表

尝试在名称前面添加静态字符串，但我不能。具体来说，我希望新表存储为:

http://www.example.com/images/stories/virtuemart/product/1200x1000.gif

这会添加到 www.example.com 前面的数据

有人可以帮忙吗？

我尝试过但没有成功:

$result = mysql_query("
  UPDATE skroutz 
  SET Image_Link=('www.example.com'
  SELECT file_url 
  FROM bonnie_virtuemart_medias 
  INNER JOIN bonnie_virtuemart_product_medias 
  ON bonnie_virtuemart_medias. virtuemart_media_id =bonnie_virtuemart_product_medias. virtuemart_media_id 
  WHERE virtuemart_product_id=Unique_ID LIMIT 1)",$db);

Answer 1

您需要使用CONCAT函数:

$result = mysql_query("
  UPDATE skroutz 
  SET Image_Link=(
  SELECT CONCAT('www.example.com', file_url)
  FROM bonnie_virtuemart_medias 
  INNER JOIN bonnie_virtuemart_product_medias 
  ON bonnie_virtuemart_medias. virtuemart_media_id = bonnie_virtuemart_product_medias. virtuemart_media_id 
  WHERE virtuemart_product_id=Unique_ID LIMIT 1)",$db);