MYSQL drop files question

[gangtriod]

hi there i was wondering if there is a way to mass drop tables in my db.

i have a db of thousandes of entries by difrent users.

i was wondering if there is a way to drop the tables of as cetain user without having to go through and drop the entreis one at a time.


any sugestions would be great

cheers

[longneck]

what do you want to "drop"? databases? tables? rows? you allude to all three in your post.

[longneck]

FYI- db's and tables are not "owned" by anyone in mysql. so you are not going to be able to drop tables based on owner.

[gangtriod]

I have found out what i had to do sorry for the cofusing questiong it hit me in the face after i made this post

thanx guys

you can close this post now