开始-cmd-运行-输入osql  -U  netcafe  -P 数据库密码

use local

go

2. 查询会员信息表是否有空值，如图：

select uniqueid from mem_localmemberbaseinfo where uniqueid is  null

3.查询会员信息表是否有重复值，如图

  select uniqueid from mem_localmemberbaseinfo group by uniqueid having count(*)>1

4.删除上述查询到的空值

  delete from mem_localmemberbaseinfo where uniqueid is null

  删除上述查询到的重复值
  delete from mem_localmemberbaseinfo where uniqueid="从1查询到重复会员的值"