Skip to content

Instantly share code, notes, and snippets.

@greggles

greggles/-

Created October 11, 2013 17:13
Show Gist options
  • Save greggles/6938499 to your computer and use it in GitHub Desktop.
Save greggles/6938499 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
-
d.o users as of nowish
mysql> select count(1), status, length(login) from users group by status, length(login);
+----------+--------+---------------+
| count(1) | status | length(login) |
+----------+--------+---------------+
| 7062 | 0 | 1 |
| 86379 | 0 | 10 |
| 483270 | 1 | 1 |
| 1000229 | 1 | 10 |
+----------+--------+---------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment