Forum: Ruby mysql command line

Announcement (2017-05-07): www.ruby-forum.com is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see rubyonrails.org/community and ruby-lang.org/en/community for other Rails- und Ruby-related community platforms.
0348fa3d994ac071598a9095196e248f?d=identicon&s=25 chriswillis10@gmail.com (Guest)
on 2006-03-12 12:21
(Received via mailing list)
does anyone know how to delete databases/tables in mysql command line?
Ce60c4f78a63b0695e4dafc4bd7964f7?d=identicon&s=25 Lou Vanek (Guest)
on 2006-03-12 12:33
(Received via mailing list)
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
0348fa3d994ac071598a9095196e248f?d=identicon&s=25 chriswillis10@gmail.com (Guest)
on 2006-03-12 14:04
(Received via mailing list)
so does that actually DELETE it?
0348fa3d994ac071598a9095196e248f?d=identicon&s=25 chriswillis10@gmail.com (Guest)
on 2006-03-12 14:05
(Received via mailing list)
don't worry about that last one!
0348fa3d994ac071598a9095196e248f?d=identicon&s=25 chriswillis10@gmail.com (Guest)
on 2006-03-12 14:29
(Received via mailing list)
so then,
what does drop table if exists do?
1fba4539b6cafe2e60a2916fa184fc2f?d=identicon&s=25 unknown (Guest)
on 2006-03-12 14:32
(Received via mailing list)
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! http://www.manning.com/books/black
F7b23ca97e51ae89341a19548aa63467?d=identicon&s=25 Tom Reilly (Guest)
on 2006-03-12 22:03
(Received via mailing list)
It seems a ligit question to me especially since Ruby interfaces so
easily with mysql.
This topic is locked and can not be replied to.