恐怖的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,
回覆