mySQL has been planing to implement stored procedures and triggers in mySQL 5 for some time now... But lately, it looks like it's just gonna get better than expected... Via Simon Willison (great blog!), from chromatic's wrap-up of OSCON day 3: Brian…...
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…...
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…