Function to clean data in tables..

Results 1 to 5 of 5
  1. #1
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Function to clean data in tables..

    Hi, I google'd and didn't found the results I wanted.. Does anyone know here how to clean up all the tables in a database like GunzDB?

    The most tables I can delete all the inserted values, but in some others I can't like: Account, Character

    Who knows how delete the data inside it:O


  2. #2
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Function to clean data in tables..

    what exactly do you want deleted?

  3. #3
    Status: Pooping eele is offline
    MemberRank
    Jul 2008 Join Date
    The NetherlandsLocation
    915Posts

    Re: Function to clean data in tables..

    Character Tables and Account tables, I already deleted the values of the Tables, but I think that there is a way easy'er than I did.

    I deleted the keys at AID and CID and than deleted all rows and than I added the Keys again ô.ô

  4. #4
    Account Upgraded | Title Enabled! PaulBub is offline
    MemberRank
    Apr 2009 Join Date
    316Posts

    Re: Function to clean data in tables..

    "DELETE * FROM table_name WHERE 1=1" I guess it would work.

  5. #5
    Freelance GunZ Developer Touchwise is offline
    MemberRank
    Aug 2009 Join Date
    The NetherlandsLocation
    754Posts

    Re: Function to clean data in tables..

    truncate gunzdb ???



Advertisement