On 10-Jan-08, at 10:32 AM, Raj Shekhar wrote: >>> If you are talking about ACID compliance, innodb & >>> falcon table engines are ACID complaint. >> >> an the rest of it is not? > > Quite a few of the mysql engines are not ACID - MyISAM being most > notable of them. Unluckily, myisam comes as the default table engine > with almost all mysql distributions that I have seen. Since mysql > supports table engines as plugins, there are some commercial as > well as > free ACID compliant table engines other than innodb and falcon.
non troll: how close to ansi compliance is mysql? Can one write an ansi compliant sql and run it on mysql? Next, an acid compliant ansi compliant sql on mysql? If not, why does mysql not follow standards - which why the so called troll bait was floated. -- regards Kenneth Gonsalves Associate, NRC-FOSS [EMAIL PROTECTED] http://nrcfosshelpline.in/web/ Foss conference for the common man: http://registration.fossconf.in/web/ _______________________________________________ ilugd mailinglist -- ilugd@lists.linux-delhi.org http://frodo.hserus.net/mailman/listinfo/ilugd Next Event: http://freed.in - February 22/23, 2008 Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/ilugd@lists.linux-delhi.org/