最近因为期刊论文涉及数据挖掘,有幸接触到了数据库操作。写一下我的操作语句和具体的感受:
1
2 #检索出疾病名,注意,or前后都要写列名!
SELECT * FROM YSL.comment
WHERE disease_name=‘疾病未填写’ OR disease_name=‘尚未确诊’
SELECT * FROM YSL.full
WHERE disease_name=“1”
3#删除上面检索结果,共删了8万多行。注意,delete后不用加*
DELETE
FROM YSL.comment
WHERE disease_name=‘疾病未填写’ OR disease_name=‘尚未确诊’