恐怖的mysql….

看到一篇anti-mysql的文章，mysql因為是免費的，所以廣為人用，但其實當中的一些bug實在很恐怖，例如：

• SELECT ‘A’ = ‘a’ is true
• Int(10) is the same as int(1) eventhough the manual says differently.
• Insert a NULL value in a NOT NULL field and the query gets executed. In short, you can’t force NOT NULL…
• This is correct according to mysql: SELECT a, b, count© FROM d GROUP BY a; what will MySQL do with the b?

Related Link: Anti-MySQL list, MySQL Gotchas,