mysql 8 添加虚拟列 作者: juoliii 时间: 2024-03-25 分类: 数据库 ```sql ALTER TABLE toolbox_littleqc ADD COLUMN result varchar(100) AS ( case when gc<0.395 or gc>0.425 then '不合格' when pct>0.048 then '不合格' when meanInsertSize>500 or meanInsertSize<300 then '不合格' when dups>0.28 then '不合格' when mappedLambda>0.05 then '不合格' when chrxy>=3.5 and chrxy<=10 then '不合格' when mappedAllbam<95 then '不合格' else '合格' end ) VIRTUAL; ``` 标签: none
评论已关闭