thanx for reply but not a good idea. Though i did it through PHP script Nitin
----- Original Message ----- From: "Mechain Marc" <[EMAIL PROTECTED]> To: "Nitin Mehta" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 16, 2004 1:38 PM Subject: RE: is this possible? > 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:[EMAIL PROTECTED] > Envoyé : vendredi 16 janvier 2004 06:28 > À : [EMAIL PROTECTED] > 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 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
