Mysql is not an ACID-compliant database. In layman terms, it's not a real database.
For example, let's say you want to count your money. Most databases have a function called COUNT which will return the exact number of what is being counted. What does mysql does? It only returns "an"...