select*from hrmdepartment;可以获取所有数据
select*from hrmdepartment where canceled!='1';一条都没有
canceled为char(1),是什么问题呢?
select*from hrmdepartment;可以获取所有数据
select*from hrmdepartment where canceled!='1';一条都没有
canceled为char(1),是什么问题呢?
空是不比较的
select*from hrmdepartment where canceled!='1' or canceled is null;