search

landv / landv.github.io

landv-blogs
https://landv.cn
2 stars 0 forks source link

银科环企删除商品信息 #79

Open landv opened 1 year ago

landv commented 1 year ago 
-- 分类
select * from GS_T_CLASSES  
--- select * from GS_T_CLASSES_SK

-- 明细商品
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and VCOMMYNAME in (
select VCOMMYNAME from GS_T_COMMODITY where NCOMMSONCLASS =5 group by VCOMMYNAME
having count (VCOMMYNAME)>1) order by VCOMMYNAME

select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (157,169,159,127,153,165,160,176,152,149,161,172,154,170,164)
delete  GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (157,169,159,127,153,165,160,176,152,149,161,172,154,170,164)