> Is there anything like the first line from mySQL?
> I need to check if a table exists and drop it if it 
> does so it can be recreated. I do not have access to
> any admin facilities on my host so I need to be able
> to do this in a script I can modify.
Found it...
'In MySQL Version 3.22 or later, you can use the keywords IF EXISTS to 
 prevent an error from occurring for tables that don't exist.'

DROP TABLE [IF EXISTS] tbl_name [, tbl_name,...] [RESTRICT | CASCADE]

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to