Re: Deleting a database

Ola Would DROP DATABASE databasename; not do it? I beleive, and I may be wrong, the only other way to delete JUST the tables is as you mentioned ( delete table gl_story, gl_submit,... OR drop table gl_story, gl_submit,... ) -- Jeremy Oliver Bluejays PC Repair tel 0208 656 1056 mob 07 855

Deleting a database

Hello all, I am playing with a weblog and I created a database in mysql for this weblog. The tables were in essence created and the installation did not go well. so I am trying to delete the database and start afresh. The database contains 40 tables and the names of the tables are gl_* *

Re: Deleting a database

Try Drop Database, section 13.2.6 in the manual. For example: drop database Foo; Rhino - Original Message - From: Ola Ogunneye [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 26, 2004 9:12 AM Subject: Deleting a database Hello all, I am playing with a weblog and I

Deleting a database....

Hello all, I have just finally finished my error free installation of mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced Server. I was able to follow a direction that helped me change the root user to myname and asign a password to myname. After that, I created 3

Re: Deleting a database....

Ola Ogunneye wrote: Hello all, I have just finally finished my error free installation of mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced Server. I was able to follow a direction that helped me change the root user to myname and asign a password to myname.

Re: Deleting a database in Mysql

drop database_name; make sure no ones is using the database_name. --- Calvin Lam [EMAIL PROTECTED] wrote: Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! -

Re: Deleting a database in Mysql

Hi Calvin, Just do drop database db_name Regards, Eric On Wed, 5 Feb 2003, Calvin Lam wrote: Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please

Re: Deleting a database in Mysql

Calvin, CL I am a newbie with this and I need help with Mysql CL How can I delete a database in Mysql DROP DATABASE database_name; Regards, -- Stefan Hinz [EMAIL PROTECTED] iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30

RE: Deleting a database in Mysql

DROP DATABASE dataBaseName; -Original Message- From: Calvin Lam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 8:50 AM To: [EMAIL PROTECTED] Subject: Deleting a database in Mysql Hi, I am a newbie with this and I need help with Mysql How can I delete a database

re: Deleting a database in Mysql

On Wednesday 05 February 2003 16:50, Calvin Lam wrote: I am a newbie with this and I need help with Mysql How can I delete a database in Mysql Use DROP DATABASE statement: http://www.mysql.com/doc/en/DROP_DATABASE.html -- For technical support contracts, goto

RE: Deleting a database in Mysql

-Original Message- From: Calvin Lam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 3:50 PM To: [EMAIL PROTECTED] Subject: Deleting a database in Mysql Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks

Deleting a database in Mysql

Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: Deleting a database in Mysql

drop database yourdatabasename; - Original Message - From: Calvin Lam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 2:50 PM Subject: Deleting a database in Mysql Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql

Re: Deleting a database in Mysql

See DROP DATABASE Doug On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote: Hi, I am a newbie with this and I need help with Mysql How can I delete a database in Mysql thanks! - Before posting, please check: