Shulou(Shulou.com)06/01 Report--

The MySQL NULLIF function and how to use it to prevent division by zero errors in the query, the NULLIF function is one of the control flow functions that take two parameters. The NULLIF function returns NULL if the first parameter is equal to the second parameter, otherwise the first parameter is returned. 1 NULLIF (expression_1,expression_2); 2, example usage SELECT NULLIF (1); SELECT NULLIF (1); SELECT NULLIF ('MySQL NULLIF','MySQL NULLIF'); NULLIF function to prevent division by zero errors in the query. If the MySQL server has ERROR_FOR_DIVISION_BY_ZERO mode enabled, an error will be issued when a zero divisor occurs. The article is from http://www.huthon.cn/.

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.