Mysql command line

ruby-talk
1

does anyone know how to delete databases/tables in mysql command line?

2

if you're referring to the mysql client program,

   drop table table_name;
   drop database db_name;

http://dev.mysql.com/doc/refman/5.0/en/drop-database.html

chriswillis10@gmail.com wrote:

···

does anyone know how to delete databases/tables in mysql command line?

3

so does that actually DELETE it?
Lou Vanek wrote:

···

if you're referring to the mysql client program,

   drop table table_name;
   drop database db_name;

http://dev.mysql.com/doc/refman/5.0/en/drop-database.html

chriswillis10@gmail.com wrote:
> does anyone know how to delete databases/tables in mysql command line?
>
>
>

4

don't worry about that last one!

5

so then,
what does drop table if exists do?

6

Hi --

···

On Sun, 12 Mar 2006, chriswillis10@gmail.com wrote:

so then,
what does drop table if exists do?

It drops the table if the table exists, without raising an error if it
doesn't.

I'm not sure how this topic ended up on this mailing list, which is
about Ruby. Can you try to find an SQL or MySQL list to discuss this
on?

David

--
David A. Black (dblack@wobblini.net)
Ruby Power and Light, LLC (http://www.rubypowerandlight.com)

"Ruby for Rails" chapters now available
from Manning Early Access Program! Ruby for Rails

7

It seems a ligit question to me especially since Ruby interfaces so easily with mysql.

dblack@wobblini.net wrote:

···

Hi --

On Sun, 12 Mar 2006, chriswillis10@gmail.com wrote:

so then,
what does drop table if exists do?

It drops the table if the table exists, without raising an error if it
doesn't.

I'm not sure how this topic ended up on this mailing list, which is
about Ruby. Can you try to find an SQL or MySQL list to discuss this
on?

David