Mysql

Page 2 / 2 (12 Posts)

mySQL 3.23 is making me sick!

No referential integrity No transactions (at least not enabled by default so hosting providers would have them) No subqueries in DELETE statements No UNION statement (can you believe it?) and of course no triggers of any kind... Not that I think mySQL…...

mySQL DISTINCT FUNCTION(...) bug

Looks like mySQL is not able to to perform the DISTINCT selection in cases like this: SELECT DISTINCT YEAR(post_date), MONTH(post_date) FROM whatever1 INNER JOIN whatever2 ON field1 = field2 ORDER BY post_date This can be worked around, but it seems…