I am trying to use the SQL Monitor to DROP all tables within a database, but not delete or DROP the whole database.
I've tried using:
DROP TABLE tbl_AG_'%'
AND
DROP TABLE tbl_AG_'\%'
AND
DROP TABLE 'tbl_AG_\%'
I've searched the http://www.mysql.com web site and read most of the DROP syntax tutorials. It doesn't seem like MySQL supports wildcard characters within table names.
Anyone know if it is possible to include wildcard characters in table names????
Individually DROPping 40 tables in a database is a pain!
Thanks in advance....
Regards,
Eliot Lee
I've tried using:
Code:
DROP TABLE tbl_AG_'%'
AND
Code:
DROP TABLE tbl_AG_'\%'
AND
Code:
DROP TABLE 'tbl_AG_\%'
I've searched the http://www.mysql.com web site and read most of the DROP syntax tutorials. It doesn't seem like MySQL supports wildcard characters within table names.
Anyone know if it is possible to include wildcard characters in table names????
Individually DROPping 40 tables in a database is a pain!
Thanks in advance....
Regards,
Eliot Lee