[thelist] MySQL Limitations

paul at one-pla.net paul at one-pla.net
Mon Feb 11 15:34:01 CST 2002

>The only reason you may want to consider switching to oracle is if you need
>to do more complex queries than MySQL can handle, but even in that area,
>the latest versions are fast catching up with oracle.

To be specific, MySQL up to 3.22 (circa 2000) does not support:

* subselects (for example: SELECT * FROM mytable WHERE myvar IN (SELECT var2 FROM ...) )

* transactions and commit/rollback (important when all statements must execute or none must, as with financial transactions; there are some partial workarounds for this)

* foreign keys and referential integrity

* stored procedures and triggers (this is in the works)

* views (this is also in the works)

* record level privileges and locking

* '--' as a comment (although beginning with 3.23.3, DuBois says, '-- ' is supported)

(from Paul DuBois' "MySQL" (2000) New Riders, pp.170-176. ISBN: 0735709211. An excellent book.)

I haven't been keeping up with the latest, so some or all of that may be different in more recent versions.

-Paul Sciortino

More information about the thelist mailing list