Run a query like this ...
USE database;
DELETE FROM tblname;
Gerald Jensen
- Original Message -
From: "Dmitry Kashlev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 4:23 PM
Subject: how to erase all data in database (table)
Ho
In the last episode (Aug 09), Dmitry Kashlev said:
> How can I erase all data except for the fields in mysql table? I just want
> to fill all data again in the same table.
TRUNCATE TABLE tablename
or
DELETE * FROM tablename
--
Dan Nelson
[EMAIL PROTECTED]
--
DELETE FROM tablename;
where "tablename" is the name of the table.
-Bennett
At 05:23 PM 8/9/2001 -0400, Dmitry Kashlev wrote:
>How can I erase all data except for the fields in mysql table? I just want
>to fill all data again in the same table.
>
>Dmitry
>
>
>--
How can I erase all data except for the fields in mysql table? I just want
to fill all data again in the same table.
Dmitry
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql