Re: Deleting a database

[BluejaysPC]

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 833 401
www.bluejayspc.co.uk
Don't forget to see our latest system offerings at our Sales website.
www.bluejayspcs.co.uk

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting a database

[Rhino]

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 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_*
> 
> * represents different names.
> 
> Is there a way to delete all the tables without individually typing the
> table names like saying delete *.* in dos?
> 
> I see that I can delete the tables by typing :
> 
> mysql> delete table gl_story, gl_submit
> 
> But is there a way to delete everything inside a database in one shot?
> 
> Thanks
> 
> Ola
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting a database....

[Eternal Designs, Inc]

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. After that, I created 3 databases
in addition to the test and mysql that were already created through the
install process.
My problem is that when I created the databases, I did not do anything
else - no tables.
I am running another application (Geeklog) and in the install of
Geeklog, I got an error message saying that the "Table gl_access already
exist" when I went to Geeklog forum help, it says that my problem is
that I had performed an unsuccessful installation prior to this
successful one, and therefore, I need to delete the table or better yet,
delete the database and create a new one to use with Geeklog
installation.
The real question is that I do not know what would happen if I delete
the database, and how do I delete the database?
I thought it is something I could do at the command prompt just the same
way I created the database:
mysql>create database dbasenow

would the following work:

mysql>delete database dbasenow

Or do I have to delete the tables in it first?  Please understand that
when I created the databases, I did not create any tables, but when I
used PHPMYADMIN, I found that the database in question has tables in it
while the other 2 that I created had nothing in them..
Thank you all in advance...

Ola

 

Hi Ola:

To delete a database use the DROP DATABASE command at the command prompt 
as follows:

drop database dbasenow

[That's, of course assuming your database is named dbasenow]
--
Peter K. Aganyo
Eternal Designs Inc.,
+1(617)344-8023 (fax & voicemail)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting a database....

[Egor Egorov]

"Ola Ogunneye" <[EMAIL PROTECTED]> wrote:
> 
> 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 databases
> in addition to the test and mysql that were already created through the
> install process.
> 
> My problem is that when I created the databases, I did not do anything
> else - no tables.
> 
> I am running another application (Geeklog) and in the install of
> Geeklog, I got an error message saying that the "Table gl_access already
> exist" when I went to Geeklog forum help, it says that my problem is
> that I had performed an unsuccessful installation prior to this
> successful one, and therefore, I need to delete the table or better yet,
> delete the database and create a new one to use with Geeklog
> installation.
> 
> The real question is that I do not know what would happen if I delete
> the database, and how do I delete the database?
> 
> I thought it is something I could do at the command prompt just the same
> way I created the database:
> 
> mysql>create database dbasenow
> 
> would the following work:
> 
> mysql>delete database dbasenow

No, the correct command is DROP DATABASE:
http://www.mysql.com/doc/en/DROP_DATABASE.html

> 
> Or do I have to delete the tables in it first?

If you remove database, all its tables will be deteted, too.

> Please understand that
> when I created the databases, I did not create any tables, but when I
> used PHPMYADMIN, I found that the database in question has tables in it
> while the other 2 that I created had nothing in them..



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Deleting a database in Mysql

[Nasser Ossareh]

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!
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Deleting a database in Mysql

[Joseph Jude]

I am using MySQL CC, the GUI client. It is easy to drop a db there. Any
GUI client should have that option. If you are newbie, I would suggest
doing this. If using command line, it is
Drop database 
Refer the manual
http://www.mysql.com/doc/en/DROP_DATABASE.html

Regards,
Joseph


>-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!
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Deleting a database in Mysql

[Victoria Reznichenko]

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 https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Deleting a database in Mysql

[Victor Pendleton]

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 in Mysql

thanks!

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Deleting a database in Mysql

[Stefan Hinz]

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 
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Deleting a database in Mysql

[Kamara Eric R-M]

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 check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Deleting a database in Mysql

[Doug Thompson]

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:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Deleting a database in Mysql

[Kevin Smith]

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
>
> thanks!
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php