Does anyone know of a resource ( on the web perhaps ) that discusses the
core differences between the different database's sql. I'm trying to write
code that produces the correct sql for a variety of databases. Such things
as Oracle's SEQUENCES versus mysql's AUTO_INCREMENT are of interest.
That's a pretty difficult request:
1) What versions? MySQL 4.0 has no stored procedures, functions, views, subselects. 4.1 added subselects. 5.0 added the rest.
Oracle 8i doesn't support ANSI-style outer joins (they use a proprietary format).
2) Different engines; MySQL supports federated,
I think it's better to pick one database and try to design and code
to its strengths and weaknesses.
I've worked on several projects in which the overall architectural
plan involved writing a database abstraction layer to keep options
open as to the specific relational db - MySQL,
