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
mysql 5.5版本下载地址:https://dev.mysql.com/downloads/mysql/5.5.html#downloads
2017-09-11