Skip to content

Instantly share code, notes, and snippets.

@thequbit

thequbit/gist:c01aa9850ab8ec6d98a2

Created March 26, 2015 15:31
Show Gist options
  • Save thequbit/c01aa9850ab8ec6d98a2 to your computer and use it in GitHub Desktop.
Save thequbit/c01aa9850ab8ec6d98a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
mysql> select count(*) from clients where date(last_check_in_datetime) = date(now());
+----------+
| count(*) |
+----------+
| 47 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from votes;
+----------+
| count(*) |
+----------+
| 312 |
+----------+
1 row in set (0.00 sec)
mysql> select count(*) from posts;
+----------+
| count(*) |
+----------+
| 190 |
+----------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment