In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] <SNIP> > 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 (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]