sqlLite

修改表结构

ALTER TABLE DeviceData ADD IsDel Integer DEFAULT 0

ALTER TABLE DeviceData ADD BidirectionalCommand text 

ALTER TABLE DeviceSharingManagement ADD DeviceSubType text 

UPDATE DeviceData set BidirectionalCommand='FINISHED'

 

取出重复数据

select * from DeviceData where substr(DonationId,1,14) in (select substr(DonationId,1,14) from DeviceData group by DonationId having count(DonationId) > 1)