Skip to content

Instantly share code, notes, and snippets.

@parsonsmatt
Created May 22, 2017 23:09
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parsonsmatt/262712516f5cc957922dd89f302596aa to your computer and use it in GitHub Desktop.
Save parsonsmatt/262712516f5cc957922dd89f302596aa to your computer and use it in GitHub Desktop.
I hate MySQL
mysql> create table garbage (`why` enum('are', 'you') not null);
Query OK, 0 rows affected (0.16 sec)
mysql> insert into garbage values ('mysql'), ('hates'), ('you');
Query OK, 3 rows affected, 2 warnings (0.02 sec)
Records: 3 Duplicates: 0 Warnings: 2
mysql> select * from garbage;
+-----+
| why |
+-----+
| |
| |
| you |
+-----+
3 rows in set (0.00 sec)
@parsonsmatt
Copy link
Author

Empty string! Not Null! ARGHGHGHGHGHG

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment