I have to re-create a table every month with a section of data from the
main table. I suppose this would be an excellent situation to use views
for but being as how MySQL doesn't have view capability yet I'm stuck
with this. It's not a big deal but I just want to make sure that
Creating,
I have researched this and can't find an answer. Maybe I am just looking
in the wrong places or not putting the correct keywords into the search
engines. So any help would be greatly appreciated. I am using MySQL with PHP.
I have some PHP scripts that create tables in a database that are
Thank You so much John and Michael. SHOW TABLES LIKE 'a%' worked like a
charm and was exactly what I was looking for. I guess my searches were
using the wrong keywords. Kind of figures. Some of my searches were
turning up 1000's of results.
How do you know whether it's an active a* table
Is there anyway to drop a group of tables with a wildcard in MySql? I have
tried:
DROP TABLE IF EXISTS division1s*
and
DROP TABLE IF EXISTS division1s(*)
but neither one works. I am hoping that there is a good useable answer to
this.
Thanks in advance
Steve Buehler
At 16:40 -0600 3/25/02, Steve Buehler wrote:
Is there anyway to drop a group of tables with a wildcard in MySql?
I have tried:
DROP TABLE IF EXISTS division1s*
and
DROP TABLE IF EXISTS division1s(*)
but neither one works. I am hoping that there is a good useable
answer to this.
The syntax
Thank you. I am still not an expert yet at MySQL and/or PHP. I learn
something new everyday. At least this list doesn't knock people down for
asking questions that could be found by either a 1 minute or a 1 month
search on the web. I will try this out in the morning. I see no reason
why
At 22:20 -0600 3/25/02, Steve Buehler wrote:
Thank you. I am still not an expert yet at MySQL and/or PHP. I
learn something new everyday. At least this list doesn't knock
people down for asking questions that could be found by either a 1
minute or a 1 month search on the web. I will try
Is there a way to drop all tables that match a certain pattern, kind of like
using a LIKE statement in DROP statement.
if this worked it would be perfect
drop table like 'TT%';
in other words dropping all the tables in a database that start with 'TT'.
Roger Karnouk
