>>MySQL is in rapid development and what it can and cannot do probably fluxuates daily. When I looked at it many ANSI 92 functions were present only as nonfunctional stubs, for the sake of 'compatibility' with the standard.
>>There is no TRANSACTION tracking, although they say it will be added later.
>>It's lite and fast, but limited.
>
>Thanks for the info Jerry. So what do you think is MySQL's appeal then? Why MySQL instead of MSDE or SQL 7 for instance?

It's FREE, has a small memory footprint and is very fast.
Also, the development team is adding 'features' all the time. I don't doubt that within a couple of years it will have CLASSIC primary and secondary keys, Transaction tracking (although they intially said this would never happen, public pressure forced them to change their minds!), and some of the current compatibility stubs will become functional.

In opinion, however, it will never reach the power and sophistication of PostgreSQL.