MySQL command to completely empty an entire database?

[Creepshow]

Hey guys,

Can anyone give the MySQL command to COMPLETELY empty a database of all data?

Thanks!

[Scott MacVicar]

DROP DATABASE `moo`;

[Kier]

Followed by

CREATE DATABASE `moo`;

of course...

[Colin F]

You'll loose both data and structure with that though.

[Kier]

I assumed that was the object... but it's a good point.

As a second thought, if you are going to use the DROP / CREATE method, ensure that you have permission for both those commands before you run either of them!