database compatibility

2006-03-22 Thread ChadDavis 
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.  Maybe
I'm asking too much to find a summary of such differences.  But I'm only
interested in using mainstream sql functinality, nothing complicated.

drop table that doesn't exist

2006-03-21 Thread ChadDavis 
I'm runnning a script that creates a few tables.  I have line that drops the
tables before the creation of the tables just in case they  already exist (
such as on a re-creation of the tables ).

mysql is giving me the following error on the drop table when I run the
script the first time -- i.e. when there isn't a table to drop yet.

 ERROR 1051 at line 1: Unknown table 'MyTable'

Is there a global db setting that will allow this statement to occur without
the error?

sequences

2006-03-21 Thread ChadDavis 
Newbie question.

Does mysql have sequences?  If not what is the functional equivalent?