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 remove inaccurate data?

Discussion in 'Databases' started by sophiejones, Feb 19, 2014.

  1. #1
    Hi Everyone,
    I am having a bulk of data. While going through my database, I found some of data are now corrupted or inaccurate. How can I remove inaccurate data from my database?
    Looking forward for your suggestions.
    Thanks
    SEMrush
     
    sophiejones, Feb 19, 2014 IP
    SEMrush
  2. skible

    skible Member

    Messages:
    21
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    41
    #2
    Depends on what kind of data it is. You could try sql commands like:

    SELECT * FROM tablename WHERE name="idontknow";
    Code (markup):
    Tablename = the name of the table
    name= column name
    idontknow = the value of which name should have.

    if you are sure that everything in there can be deleted:

    DELETE FROM tablename WHERE name="idontknow";
    Code (markup):
    done.
     
    skible, Feb 28, 2014 IP