UPDATE tdb_goods g INNER JOIN tdb_goods_brands b ON g.brand_name=b.brand_name SET g.brand_name=b.brand_id
可以不用AS
可以不用AS
2017-09-12
SELECT id,sex FROM user GROUP BY sex HAVING id>1|| id<5。对id范围在1到5之间的数据根据性别进行分组。亲测可行
2017-09-12