Jump to content


Photo

Empty a database?


  • Please log in to reply
2 replies to this topic

#1 Random

Random
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts
  • LocationIndiana

Posted 03 April 2003 - 07:07 PM

Is there a way to write a PHP script that I just execute that will completely remove everything from a database? Thanks.

#2 DocSeuss

DocSeuss
  • Members
  • PipPipPip
  • Advanced Member
  • 73 posts
  • LocationTexas, USA

Posted 03 April 2003 - 07:18 PM

you can use

DELETE FROM table;

on all your tables, I don\'t know off hand if there is a single command to do a whole database.

This will remove all data from tables but the tables themselves will remain.
"Unlimited budget? Great, for $5,000,0000 we will run your ad banner for one year"  ----Rasmus Lerdorf

#3 pallevillesen

pallevillesen
  • Members
  • PipPipPip
  • Advanced Member
  • 135 posts
  • LocationDenmark

Posted 03 April 2003 - 07:20 PM

DROP

...check the syntax

P.
Palle Villesen, www.birc.dk [br]Bioinformatics Research Center




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users