Emptying entire database

[86Stang]

101 question here...

 

I need to erase all data from the database before running an import.  Don't ask - it's management's decision.  Anyway, could someone school me in the ways to erase all data in the DB from a php file?  I'm already connected to the DB, can import, etc., I just need to figure out how to flush the current data first.

[MadTechie]

Depends on rights, but drop database will do it

 

DROP {DATABASE | SCHEMA} [iF EXISTS] db_name

[86Stang]

I got a different idea but I think it'll work the same (?)

 

mysql_query("DELETE FROM table_name") or die(mysql_error());

 

Seems to be working ok but time will tell.

[bubblegum.anarchy]

Use TRUNCATE instead so that any auto_increment values are reset.

 

TRUNCATE tbl_name 

[brownka]

put all the names of the tabes in an array and  use truncate. im a noobie but im sure there is a way to query all the names of the tables to automate the array creation. goodluck!

 

 

$tables=array("grades","inclass","submitted","posted","classes");

foreach($tables as $table)

{

$query = "truncate  $table";

$result = mysql_query($query,$conn) or die("Query error");