MySQL 4 and any version of MySQL over the MyISAM storage engine are missing some basic SQL standard transactional capability. They should not be used for serious DBMS applications.