weixin_45006210的博客

ERROR 1690 (22003): DECIMAL UNSIGNED value is out of range in '(ceshi.goods.market_price - ceshi.goods.shop_price)方法一：mysql> select goods_id,goods_name,cast(market_price as signed) - cast(shop_...

目的 查询每个栏目下，goods_id最大的商品本次使用的是MySQL8.0进行测试在MySQL查询中，from中嵌套(sql语句)，当sql最后的语句是order by 句子时，会被忽略掉，从而查询不到想要的结果这是原始表，称 表1子查询表，称表2mysql> select goods_id,cat_id,goods_name from goods-> order by...