On Mon, Dec 8, 2008 at 3:24 PM, Chris <dmagick@xxxxxxxxx> wrote: > > And 'exists' is not for mysqldump. >> >> >> DROP TABLE IF EXISTS `mytable`; >> > > "if exists" can be used in lots of places other than "drop table", like > triggers, functions and i'm sure other things. > > I said, I've seen EXIST in a result of a mysqldump before, which is not >> wrong is it? Unless I'm hallucinating... Or is EXISTS something completely >> different? >> > > Yes it is completely different. Sorry, I couldnt find EXIST there, only EXISTS. > > > > http://dev.mysql.com/doc/refman/5.0/en/exists-and-not-exists-subqueries.html > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > -- Tim-Hinnerk Heuer http://www.ihostnz.com -- Web Design, Hosting and free Linux Support