Ummm... How about "delete * from table_name" ?
As described in just about every SQL book/manual/tutorial in existance I
would presume. 8)
Best regards,
Martin Edelius
Spirex Digital Design
--------------------------------
www: http://www.spirex.se
Mail: martin.edelius@stripped
Phone: +46-31-514651, 0708-113711
Fax: +46-31-514331
Aröds Industriväg 3c
S-422 43 Hisings Backa
--------------------------------
If I haven't got back to you or done what I'm supposed to, let me know again
as I have too much to do for my own good...
----- Original Message -----
From: "John King" <mysql30@stripped>
To: <mysql@stripped>
Sent: Thursday, March 16, 2000 7:53 PM
Subject: How to delete all records.
> Hi All,
>
> I have a lot of junk data in my database. I don't want to delete my table.
> However,is it possible to delete all records from an existing table?
>
> Thanks in advance for any help.
>
> John
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread31421@stripped
>
> To unsubscribe, send a message to:
> <mysql-unsubscribe-martin.edelius=spirex.se@stripped>
>
>
