Trevor ...
Do you want to drop the tables, or simply delete the data in them and retain
the table structure?
To delete data ...
USE databasename;
DELETE * FROM tablename;
To drop tables ...
DROP TABLE [IF EXISTS] tablename1 [, tablename2,...] [RESTRICT |
CASCADE]
If you drop a table, then need to store data in it, you will have to
re-create it.
----- Original Message -----
From: "Trevor Tregoweth" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]>
Sent: Tuesday, August 27, 2002 8:12 PM
Subject: Re: Command Line
Hi
I am very new to mysql, so any help please....
how to drop tables from a database from the command line
i have 6 tables in there, and need to be able to flush all the data out, (of
2 tables only) so there might be another way
Thanks
Trevor
---------------------------------------------------------------------
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
