Skip to content

Instantly share code, notes, and snippets.

@kolyanok
Last active December 4, 2018 18:48
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kolyanok/10f976a3d60e9a35e6b5c1416db5d753 to your computer and use it in GitHub Desktop.
Save kolyanok/10f976a3d60e9a35e6b5c1416db5d753 to your computer and use it in GitHub Desktop.
SELECT * FROM Messages
+----+---------+------------+-----------------------------------------------------------------+
| id | from_id | date | text |
+----+---------+------------+-----------------------------------------------------------------+
| 1 | 1 | 1535699110 | I’m just a fucking regular user |
| 2 | 3 | 1535699854 | And I’m a cheater: fuck fuck fuck fuck fuck fuck fuck
SELECT * FROM Offensive
+----+------+------------+---------+------------+
| id | type | in_message | from_id | text |
+----+------+------------+---------+------------+
| 1 | 1 | 1 | 1 | fucking |
| 2 | 1 | 2 | 3 | fuck |
| 3 | 1 | 2 | 3 | fuck |
| 4 | 1 | 2 | 3 | fuck |
| 5 | 1 | 2 | 3 | fuck |
| 6 | 1 | 2 | 3 | fuck |
| 7 | 1 | 2 | 3 | fuck |
| 8 | 1 | 2 | 3 | fuck |
+----+------+------------+---------+------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment