Quote:
Originally Posted by eMonk
btw isn't there a way to delete ALL data from a database? deleting data in tables one by one is a bit tedious. good thing i didn't have too many.
|
You could just drop the entire database and then create it again at the top of your script.
drop database dbname;
create dbname;
use dbname;
create table....... etc etc etc