文章

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

*