第一步:将字段为空的信息更改为默认值
第二步:更改字段为非空
第三步:设置默认值约束
update TableImageQuality set ImageScore= 0 where ImageScore is null ALTER TABLE TableImageQuality ALTER COLUMN ImageScore VARCHAR(10) not null update TableImageQuality set FilmScore= 0 where FilmScore is null ALTER TABLE TableImageQuality ALTER COLUMN FilmScore VARCHAR(10) not null update TableImageQuality set DImageScore= 0 where DImageScore is null ALTER TABLE TableImageQuality ALTER COLUMN DImageScore VARCHAR(10) not null update TableImageQuality set ReportScore= 0 where ReportScore is null ALTER TABLE TableImageQuality ALTER COLUMN ReportScore VARCHAR(10) not null update TableImageQuality set AuditScore= 0 where AuditScore is null ALTER TABLE TableImageQuality ALTER COLUMN AuditScore VARCHAR(10) not null update TableImageQuality set ApplicationScore= 0 where ApplicationScore is null ALTER TABLE TableImageQuality ALTER COLUMN ApplicationScore VARCHAR(10) not null alter table TableImageQuality add default (0) for ImageScore with values alter table TableImageQuality add default (0) for FilmScore with values alter table TableImageQuality add default (0) for DImageScore with values alter table TableImageQuality add default (0) for ReportScore with values alter table TableImageQuality add default (0) for AuditScore with values alter table TableImageQuality add default (0) for ApplicationScore with values
查询 昨天数据比前一天数据温度高....
SELECT *
FROM temperature_records t1
JOIN temperature_records t2 ON DATE_SUB(t1.date, INTERVAL 1 DAY) = t2.date
WHERE t1.temperature > t2.temperature;
博客内容主要用于日常学习记录,内容比较随意,如有问题,还需谅解!!!