SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Exclamation MYSQL drop files question

    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

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    what do you want to "drop"? databases? tables? rows? you allude to all three in your post.

  3. #3
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    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.

  4. #4
    SitePoint Member
    Join Date
    Jan 2006
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •