请帮忙修改一下
update jc_goods as g set g.page_title = CONCAT(cat_name,' ',goods_name,' wholesale ',goods_id)
from jc_category as c where g.cat_id = c.cat_id and g.goods_id = 7621;
update jc_goods as g set g.page_title = CONCAT(cat_name,' ',goods_name,' wholesale ',goods_id)
from jc_category as c where g.cat_id = c.cat_id and g.goods_id = 7621;
set g.page_title = CONCAT(cat_name,' ',goods_name,' wholesale ',goods_id)
where g.goods_id = 7621;
类似问题建议直接参考一下MYSQL手册中的语法说明和例子。