if you just wanna delete everything from the tables you can do
DELETE FROM table_name;
for each table. or you can do DROP table_name; for each one but then you
have to re-create each table that you drop with CREATe TABLE ( stuff here
);
Only use DROP table_name; if you know the structure of each table. If you
need the table names do SHOW TABLES; and if you need their structure use
DESCRIBE table_name;
Adam
On Wed, 28 Aug 2002, Trevor Tregoweth wrote:
> 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
