Printable View
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
what do you want to "drop"? databases? tables? rows? you allude to all three in your post.
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.
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