SHOW:
|
|
- or go back to the newest paste.
| 1 | - | INSERT INTO analytics (type,path) |
| 1 | + | SET @year = extract(year FROM now()); |
| 2 | - | SELECT %d,'%s' FROM analytics WHERE NOT EXISTS ( |
| 2 | + | SET @month = extract(month FROM now()); |
| 3 | - | SELECT %d AS tmp FROM analytics WHERE |
| 3 | + | INSERT INTO analytics (type,path) |
| 4 | - | (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND type=%d AND path='%s') |
| 4 | + | SELECT %d, |
| 5 | - | ) LIMIT 1; |
| 5 | + | '%s' |
| 6 | - | UPDATE analytics SET counter = counter + 1 WHERE (MONTH(ts) = MONTH(NOW()) AND YEAR(ts) = YEAR(NOW()) AND path='%s' AND type=%d); |
| 6 | + | FROM analytics |
| 7 | WHERE NOT EXISTS ( | |
| 8 | SELECT %d AS tmp | |
| 9 | FROM analytics | |
| 10 | WHERE extract(year FROM ts) = @year | |
| 11 | AND extract(month FROM ts) = @month | |
| 12 | AND `type`=%d | |
| 13 | AND `path`='%s' | |
| 14 | LIMIT 1 | |
| 15 | ); | |
| 16 | UPDATE analytics | |
| 17 | SET counter = counter + 1 | |
| 18 | WHERE extract(year FROM ts) = @year | |
| 19 | AND extract(month FROM ts) = @month | |
| 20 | AND `type`=%d | |
| 21 | AND `path`='%s'; |
