通过tdb_goods_cates数据表来更新tdb_goods表 怎么解决
UPDATE tdb_goods INNER JOIN tdb_goods_cates ON goods_cate = cate_name -> SET goods_cate = cate_id ;
ERROR 1267 (HY000): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
UPDATE tdb_goods SET goods_cate='$id'; 我之前报错时候没有解决 写了这一句话 后来问题解决了 id没办法改