从具有 where 条件的列中删除特定值? [英] Delete specific values from column with where condition?

问题描述

我想从具有 WHERE 条件的一列中删除特定值/数据.换句话说，我不想删除完整的行.可能吗?

I want to delete specific values/data from one column with the WHERE condition. Putting in another way, I don't want to delete the complete row. Is it possible?

推荐答案

UPDATE YourTable SET columnName = null WHERE YourCondition

这篇关于从具有 where 条件的列中删除特定值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！