MySQL中if的写法
标签：col sql dev 判断 -- span 写法 pre div
MySQL中if的写法
if 判断，如果 device_num 的值为1，则赋值为100，反之为200
SELECT
district,
shop_name,
IF
( device_num = 1, 100, 200 ) AS device_num
FROM
`t_life_shop`