Delete tables

Greetings,

Could I make use of MySQL query to delete all tables
start with '_' (underscore)?

Thanks in advance and I'm using MySQL 4.1.16.



__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Delete tables

You can specify multiple tables to drop in 1 SQL statement:

drop table _tbl1,_tbl2,_tbl3;

If you are refering to wildcards, no you cannot. Cheers.

Armando

ascll wrote:
> Greetings,
>
> Could I make use of MySQL query to delete all tables
> start with '_' (underscore)?
>
> Thanks in advance and I'm using MySQL 4.1.16.
>
>
>
> __________________________________________
> Yahoo! DSL – Something to write home about.
> Just $16.99/mo. or less.
> dsl.yahoo.com
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Delete tables

You cannot directly drop tables by wildcards. If you wanted to do that,
you would have to do some programming in your client and use the output
of

SHOW TABLES LIKE 'pattern'

To construct some SQL like

DROP TABLE table1,tables2, ...

John B.
-----Original Message-----
From: ascll [mailto:ascll@yahoo.com]=20
Sent: Tuesday, 3 January 2006 4:33 PM
To: win32@ lists.mysql.com
Subject: Delete tables

Greetings,

Could I make use of MySQL query to delete all tables
start with '_' (underscore)?

Thanks in advance and I'm using MySQL 4.1.16.


=09
__________________________________________=20
Yahoo! DSL - Something to write home about.=20
Just $16.99/mo. or less.=20
dsl.yahoo.com=20



--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org