1.修改数据库中某个表的字段属性允许为空
ALTER table omp_mdm_report_task_copy1 change ecode ecode VARCHAR(64) null;
2.修改数据库中某个表中的某个字段为指定值
update omp_mdm_dbzq_device_alarm_copy1 set CONTENT = CONCAT('用机时长',CONTENT,'分钟')
WHERE ALARMPARAM = '7'
and CONTENT is not null and CONTENT != '';
3.修改涉及违规源
update omp_mdm_dbzq_device_alarm_copy1 set alarmSourceContent =CONCAT(SUBSTRING_INDEX(SUBSTRING_INDEX(CONTENT,'-',-2),'-',1),'-支出-',SUBSTRING_INDEX(CONTENT,'-',-1))
WHERE ALARMPARAM = '16' and CONTENT is not null and CONTENT != '';
4.添加数据
insert into `omp_mdm_app_permission_item`(`id`,`app_type`, `module`, `sub_module`, `enable_status`) values(35,0,'辅助','明水印',0);
5.删除在某个时间之后的数据
Delete from omp_mdm_administratorinfo where createTime>'2022-06-01 09:46:16';
6.修改某个时间段之后的数值
update omp_mdm_personal_info_collect_list SET deviceId=12772 where dayTime >= '2022-06-22';