How to remove inaccurate data?

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

0
  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
     
    sophiejones, Feb 19, 2014 IP
  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