Shulou(Shulou.com)05/31 Report--

This article mainly talks about the different uses of is, is not and in mysql. Interested friends may wish to have a look at them. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the different uses of is, is not and in mysql.

# case: query the name and bonus rate of employees without bonus

The # = or sign cannot determine whether it is equal to a null value, but it can be judged by is and is not

SELECT last_name, commission_pctFROM employeesWHERE commission_pct IS NULL

# case: query with bonus

SELECT last_name, commission_pctFROM employeesWHERE commission_pct IS NOT NULL

Security is equal to:, you can also judge null values and normal type values

SELECT last_name, commission_pctFROM employeesWHERE commission_pct NULL; so far, I believe you have a deeper understanding of "the different uses of is, is not and in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.