repo.or.cz
/
sqlgg.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
sql: parse generated columns
[sqlgg.git]
/
test
/
bug39_select_if.sql
blob
7c2f85ffc2f76fba3ccfea98d8a2ea74bff612ca
1
create table profiles (id int, host text, today_count int);
2
select id, host, if(@x < now() - interval 1 day, 0, today_count) from profiles;