To drop all tables, yes do a drop database.
To drop all with something like a exclude, no.
What you can do is an export of the tables you don't want to drop, then do a drop database
+ create database + import
Marc.
-----Message d'origine-----
De : Nitin Mehta [mailto:nitinmehta@stripped]
Envoyé : vendredi 16 janvier 2004 06:28
À : mysql@stripped
Objet : is this possible?
hello everybody,
i was wondering, if there's a single command to drop all or selected tables from the
database, something like, where i can give the table names (1-2-3) not to be deleted.
Thanx in advance
Nitin
