sql语句修改某个字段的部分内容
update 表名 set 字段 = replace(字段, ‘要修改的内容’ , ‘修改后的内容’);
sqlite> update tndata_traindata set train=replace(train,'<enum_b><ColonDianFenMiao></enum_e>','<enum_b><ColonDianFenMiao><ColonNotReadTel></enum_e>') where type='num:num' and id=9977035;
sqlite> select * from tndata_traindata where type='num:num' and id=9977035;
9977035|num:num|<enum_b><ColonDianFenMiao><ColonNotReadTel></enum_e>歌曲时长, <begin>02:13<ColonFenMiao> 。|0|1000000|<ColonFenMiao>
删除没有指定数据的字段
delete from probedatas_traindata where type='hz/hz' and train not like '%<enum_b><CSlashMei><CSlashChuYi><CSlashNotRead></enum_e>%'