mysql问题记录

1.sql语句select * from db_table where field != 12;，当field值为null时，查不到该结果，sql语句需要修改为select * from db_table where field != 12 or field is null;