List:General Discussion« Previous MessageNext Message »
From:Jason Stechschulte Date:December 28 2000 3:22pm
Subject:RE: Resetting a DB without dropping it.
View as plain text  
Sorry, I'm a dumbass.  What you want to do is drop table
table_name for each table in the database.

Jason Stechschulte
jpstech@stripped

-----Original Message-----
From: Jason Stechschulte [mailto:jpstech@stripped]
Sent: Thursday, December 28, 2000 10:17 AM
To: R. Brong; mysql@stripped
Subject: RE: Resetting a DB without dropping it.


delete from table_name;

Jason Stechschulte
jpstech@stripped

-----Original Message-----
From: R. Brong [mailto:bob@stripped]
Sent: Thursday, December 28, 2000 9:07 AM
To: mysql@stripped
Subject: Resetting a DB without dropping it.


Hi,

Im wondering if there is a way to reset a db and wipe out
everything in it
(tables/data...everything!) , without dropping it. Im afraid if I
drop it,
my provider will not get around to recreating one for me till
after New
Years. Any ideas? Ive scoured the net, as well as Paul Dubois'
book that Im
attempting to learn mysql by, but have found nothing that address
this.
Any help is appreciated.
Thanks!
Bob


--
-----------------------------------------------------------------
----
Please check "http://www.mysql.com/documentation/manual.php"
before
posting. To request this thread, e-mail
mysql-thread60079@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-jpstech=unoh.edu@stripped>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php



--
-----------------------------------------------------------------
----
Please check "http://www.mysql.com/documentation/manual.php"
before
posting. To request this thread, e-mail
mysql-thread60083@stripped

To unsubscribe, send a message to:
    <mysql-unsubscribe-jpstech=unoh.edu@stripped>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php


Thread
Resetting a DB without dropping it.R. Brong28 Dec
  • RE: Resetting a DB without dropping it.Jason Stechschulte28 Dec
    • RE: Resetting a DB without dropping it.Jason Stechschulte28 Dec