On Mon, Dec 8, 2008 at 5:06 PM, Chris <dmagick@xxxxxxxxx> wrote: > German Geek wrote: > >> >> >> On Mon, Dec 8, 2008 at 3:24 PM, Chris <dmagick@xxxxxxxxx <mailto: >> 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. >> > > If you're going to be that pedantic, "exist" isn't in mysqldump either :P > I know it's pedantic, but unfortunately computers are strictly pedantic and I wasn't sure why you said "if exists" can be used in lots of places other than "drop table", like triggers, functions and i'm sure other things." I was just stating that I saw it in a dump and I never really used it, so assume(d), it's not very important because you can do the same thing with IN etc and other conditions, can't u? Anyway, this discussion is getting rediculous. Let's move on. Didn't mean to offend anyone here. Don't worry about answering the last question if you also think it's irrelevant... All good. :) > > -- > Postgresql & php tutorials > http://www.designmagick.com/ > > -- Tim-Hinnerk Heuer http://www.ihostnz.com -- Web Design, Hosting and free Linux Support
