Re: [PHP] How do I delete a mySQL table?
On Mon, 2003-06-16 at 14:22, zavaboy wrote: > How do I delete a mySQL table? (Just what's in the subject) Well, this is a MySQL question, not a PHP question, but in PHP you would do it like this: mysql_query("DROP TABLE $table_name", $dbh); Just make sure that the user PHP is running as has permission to drop tables. The MySQL manual page for DROP TABLE: http://www.mysql.com/doc/en/DROP_TABLE.html Good luck, Torben -- Torben Wilson <[EMAIL PROTECTED]>+1.604.709.0506 http://www.thebuttlesschaps.com http://www.inflatableeye.com http://www.hybrid17.com http://www.themainonmain.com - Boycott Starbucks! http://www.haidabuckscafe.com - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How do I delete a mySQL table?
Thanks! "David Nicholson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hello, This is a reply to an e-mail that you wrote on Mon, 16 Jun 2003 at 22:22, lines prefixed by '>' were originally written by you. > How do I delete a mySQL table? (Just what's in the subject) > - Zavaboy > [EMAIL PROTECTED] > www.zavaboy.com Connect to the mysql server, select the db then use: mysql_query("DROP TABLE table_name"); David. -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirley in PHP) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How do I delete a mySQL table?
DROP TABLE `tablename` -Original Message- From: zavaboy [mailto:[EMAIL PROTECTED] Sent: Monday, June 16, 2003 5:22 PM To: [EMAIL PROTECTED] Subject: [PHP] How do I delete a mySQL table? How do I delete a mySQL table? (Just what's in the subject) -- - Zavaboy [EMAIL PROTECTED] www.zavaboy.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How do I delete a mySQL table?
Hello, This is a reply to an e-mail that you wrote on Mon, 16 Jun 2003 at 22:22, lines prefixed by '>' were originally written by you. > How do I delete a mySQL table? (Just what's in the subject) > - Zavaboy > [EMAIL PROTECTED] > www.zavaboy.com Connect to the mysql server, select the db then use: mysql_query("DROP TABLE table_name"); David. -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirley in PHP) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php