Re: Command Line
| From: | Gerald R. Jensen | Date: | Wed, 28 Aug 2002 01:20:33 +0000 |
| Subject: | Re: Command Line | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114315@lists.php.net to get a copy of this message | ||
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" <trevor@txc.net.au>
To: "mysql" <mysql@lists.mysql.com>; "PHP"
<php-general@lists.php.net>
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 <mysql-thread118146@lists.mysql.com>
To unsubscribe, e-mail
<mysql-unsubscribe-autodata=execpc.com@lists.mysql.com>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php