PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
My wish is a simpel one (i hope).
I need a mysql query to drop multiple tables from my database.
I have a prefix of the name of several tables and I wish to drop all tables that begins with that name.
is this possible?
if not how can I get all tables that begins with that prefix and then delete them one by one?
hmm... a bit too easy....
As I said I want to drop tables with the same prefix.
i.e. if I have 3 tables t1,t2 and s1
and I want to drop all the tables that begins with a t (assuming I don't know how many there are and what comes after 't')
can it be done?