1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to delete old rows from my heavy DB table?

Discussion in 'Databases' started by helmuc, May 8, 2012.

0
  1. #1
    Hi. Please help me. Here is the screenshot of Stats table that is full with old data:

    [​IMG]

    How can I save my time and delete rows of all the years except 2012?

    ... even when I choose to show 1000 rows - it gets more than 2400 pages and manually it might take at least 1 day to clean old data :(
    [​IMG]

    I really appreciate your help,
    Helmuts
     
    helmuc, May 8, 2012 IP
  2. helmuc

    helmuc Well-Known Member

    Messages:
    42
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #2
    just an update:

    here is a screenshot of Structure tab:
    [​IMG]

    anybody??
     
    helmuc, May 8, 2012 IP
  3. helmuc

    helmuc Well-Known Member

    Messages:
    42
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #3
    The question can be closed - it is sorted - I have already removed the data by running SQL query... - found a detailed solution in another forum.

    tx anyway,
    Have a good day
    Helmuts
     
    helmuc, May 8, 2012 IP
  4. imranamen6

    imranamen6 Active Member

    Messages:
    947
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    98
    Digital Goods:
    1
    #4
    Can you please post the query for our future reference..
     
    imranamen6, May 14, 2012 IP
  5. fatur_cell

    fatur_cell Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    be careful. you must check and make sure isn't that table link with another tables?
     
    fatur_cell, Jul 10, 2012 IP