详解mysql不等于null和等于null的写法

SELECT * FROM sys_teacher WHERE teacher_name IS NOT NULL AND teacher_name <>''

SELECT * FROM sys_teacher WHERE teacher_name = '' OR teacher_name IS NULL