depends entirely on what version of MySQL you are using, or proposing to use, but
this should point you in the right direction.
I still have a very good book form O'Reilly, I think its SQL in a Nutshell, but its quite old, and compares MySQL 3.22 with Oracle, SQL server & Postgres. If that books has been updated that might be a good starting point
In my view MySQL is pretty good on the SQL complinace side... it does miss soem of the more esoteric fnctions other db's have, but it has its own little wrinkles. It does have fewer legacy issues form what I've seen (ie we did this that way in 1991m therefore we must keep doing things that way in 2007