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

This article mainly introduces how to use the mysql case sentence, hoping to supplement and update some knowledge, if you have other questions to understand, you can continue to follow my updated article in the industry information.

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle.

So how to use the mysql case statement?

Mysql case statement usage:

Structure: case when... Then... End

1. Change its value while judging

Eg:

Select OperatorAccount, case when CreateTime > '2016-02-14 16 then 24 then' after' when CreateTime

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.