隐藏商品(直接数据库隐藏全不显示）

wbv123

隐藏商品
create table #disable_u_ware_q(id int)
update u_ware_q set wareid =’A’+wareid,status=2 where wareid in (‘194610′,’194608′,’194612’)
drop table #disable_u_ware_q

select REPLACE(wareid,’A’,”),* from u_ware_q where wareid like ‘A%’
–恢复之前请查看商品编号wareid字段是不前面有A
create table #disable_u_ware_q(id int)
update u_ware_q set wareid =REPLACE(wareid,’A’,’196563′),status=1 where wareid like ‘A%’
drop table #disable_u_ware_q

零售查询编码下商品名为空

select * from u_ware where wareid =’196563′
select * from u_ware_q where wareid =’196563′

update u_ware_q set wareid=’196563′ where wareid like ‘%196563%’ 恢复（无A）