11.2移动序列号许可兼容新的出货错误

所有oa第一次查询outNum都设置为0

-- select * from m_contract where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C';

-- update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 52;
-- update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 2;

-- delete from m_contract where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 8388608;

-- select * from m_contract group by sn,modelID HAVING COUNT(*) > 1

-- select * from m_contract a where (a.sn,a.modelID) in (select * from m_contract group by sn,modelID HAVING COUNT(*) > 1);


-- select * from m_contract group by sn = '',modelID HAVING COUNT(*) > 1

-- select * from m_contract group by sn,modelID HAVING COUNT(*) > 1




# 删掉错误数据
# 删掉重复的测试数据
delete from m_contract where id = 137;
# 删掉最近有问题的数据
delete from m_contract where id in (216,217,218,219);

# 修改最近新出的数据

update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 512;
update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 2;

##一、修改最近有问题的oa许可

oa的修改有问题

用户买了 核心和数据分析，发现买错了，在oa修改，把数据分析改成了路径导航，

1.修改后序列号发生了变化YEUHJ-R05RF-557FU-7H0Z5-7EL65 变成了7Z49Z-235Y6-78ZN9-20G99-1BE7C

2.查询后，3个模块都存在，如图：

##二、通过修改sql改正

###1.查询

select * from m_contract where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C'

发现了有重复sql数据

###2.sql查重

查重sql：
select * from m_contract a where (a.sn) in (select sn from m_contract group by sn,modelID HAVING COUNT(*) > 1);

发现有重复的数据库

如果数据重复了一次出货， outNum = 0 会改为 4， 数据递增，重大问题，单发现4c这个是测试数据，72是这次出问题的数据还没有出过货，故不予修改。

###3.改正

# 删掉错误数据
# 删掉重复的测试数据
delete from m_contract where id = 137;
# 删掉最近有问题的数据
delete from m_contract where id in (216,217,218,219);

# 修改最近新出的数据

update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 512;
update m_contract set outNumber = 0 , available = 1 where sn = '7Z49Z-235Y6-78ZN9-20G99-1BE7C' and code = 2;