1、字符串拼接：update products a,categorys b set a.categoryNumbers = concat(b.parent,",",a.categoryId,",")where b.id = a.categoryId…