开发者

How to query for err in MySQL?

开发者 https://www.devze.com 2022-12-08 00:12 出处:网络
I added a column to my table that does not allow null. I guess that is why some of my rows now have real values in the column but some other rows now have (err) in the column. How can I query for this

I added a column to my table that does not allow null. I guess that is why some of my rows now have real values in the column but some other rows now have (err) in the column. How can I query for this?

开发者_高级运维
select * from Table where new_column = err

That doesn't work.


select * from Table where new_column='err'


select * from Table where new_column is null I think this will work, but my MySQL skills are rusty

0

精彩评论

暂无评论...
验证码 换一张
取 消