Mailing List Archive


Back to the month index Back to the list index
Barry Hemphill (ubu@easynet.on.ca)
Wed, 15 Jan 1997 15:04:00 +5 

Message-Id: <199701152010.PAA26798@puppy.easynet.on.ca>
From: "Barry Hemphill" <ubu@easynet.on.ca>
Date: Wed, 15 Jan 1997 15:04:00 +5
Subject: Re: [mSQL] How to clean up a table ?

How about even quicker and cleaner (well, to my mind). Presuming you
remember the table structure,

drop table tablename

Then just recreate it.

Barry

On 15 Jan 97 at 10:49, David Perry wrote:

> Giancarlo,
>
> The 'WHERE' Clause is optional.
>
> If you do:
>
> 'DELETE from TABLENAME' it's a scorched earth policy. - All gone.
>
Barry Hemphill EasyNet Inc.
System Administrator Cambridge, Ontario, Canada
ubu@easynet.on.ca (519)654-9999 fax(519)654-0301

"Star Trek is a metaphor for life. The most important man
sits in the most comfortable chair in front of a big screen
and tells everyone else what to do."
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!