常用sql汇总

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';