调试数据

select * from agent order by agentid desc

 

delete from agent where agentid >2167 

delete from [user] where [uid] >2913

 

update  agent set misindexshow =1 where agentid >2312 and agentid < 2320

 

SELECT *

FROM agent where mname like  '%玩具%'

 

select * from agent where cateid = 36

select * from agent where cateid = 8 and mname like '%鞋%'

 

update agent set cateid = 9 where cateid = 8 and mname like '%鞋%'

 

delete  from [agent] where Mname=''

 

insert TBSupplierProperty (agentid) select agentid from [agent] where mstatus = 1