if用法
if(条件表达式,结果1,结果2)
表达式中间没有逗号,
例如:
SELECT DISTINCT if(
t = '21'
and page = 'home'
and block = 'a'
and id = '001',
u,
NULL
)
) as user
FROM table1
if用法
if(条件表达式,结果1,结果2)
表达式中间没有逗号,
例如:
SELECT DISTINCT if(
t = '21'
and page = 'home'
and block = 'a'
and id = '001',
u,
NULL
)
) as user
FROM table1