欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

mysql-MySql查询的问题,关于库存量的查询操作

程序员文章站 2022-05-23 08:27:12
...
mysqlselect

CREATE TABLE who_tmp_real_stock2
SELECT SUM( num ) AS real_stock,goods_id AS goods_id_new
FROM who_goods_stock
GROUP BY goods_id_new
ALTER TABLE who_tmp_real_stock2
ADD UNIQUE (goods_id_new)
SELECT a.goods_id as goods_id,cat_id, d.real_stock, a.goods_sn as goods_sn,goods_name,keywords,is_on_sale,is_delete,
is_best,is_new,is_hot,is_promote,shop_price*100 as shop_price,(shop_price*6.3-in_price)*1000 as profit,
last_update,goods_number,goods_material,goods_color,b.goods_sku_value,customer_rate_num,
(c.sale_num*15+c.stock_num*2) as stock_num,pattern_value,a.add_time

from who_goods_desc b,
who_privilegestocknum c,
who_goods a LEFT JOIN
who_tmp_real_stock2 d ON a.goods_id=d.goods_id_new

where a.goods_id=b.goods_id and
a.goods_id=c.goods_id and
a.goods_id>0 and
c.stock_num>0 and
is_on_sale=1 and
is_delete=0 and
is_freeshipping=0 and
a.goods_number>0
select a.*
from who_goods a
where a.goods_id=$id

SELECT a.goods_id AS goods_id, cat_id, a.goods_sn AS goods_sn, goods_name, keywords, is_on_sale, is_delete,
is_best,is_new, is_hot, is_promote, shop_price *100 AS shop_price, last_update, goods_number, goods_material,
goods_color, pattern_value, c.real_stock
FROM who_goods AS a,
who_goods_desc AS b LEFT JOIN who_tmp_real_stock c ON b.goods_id=c.goods_id_new

WHERE a.goods_id = b.goods_id
AND is_on_sale =1 AND
is_delete =0 AND
is_freeshipping =0 AND
a.goods_number >0
想获取库存量大于0的商品信息,不知道这个sql是不是

相关标签: mysql select