sequences

2006-03-21 Thread ChadDavis
Newbie question. Does mysql have sequences? If not what is the functional equivalent?

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. w

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. Mayb