CODEWITHSUNDEEP
mysql
user2935177
user2935177

Reputation: 119

to ignore duplicates and insert new record in mysql

I have a table name course. It has following data in it:

mca
bca
msc
me

Now when I enter 2 values at a time mca mtech. It should accept mtech and ignore mca. Please anyone help to solve.

Field   Type    Collation   Attributes  Null    Default Extra   Action
    id  int(15)         No  None    AUTO_INCREMENT   Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext
    register_number varchar(255)    latin1_swedish_ci       No  None         Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext
    name    varchar(255)    latin1_swedish_ci       No  None         Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext
    course_code varchar(255)    latin1_swedish_ci       No  None         Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext
    subject_code    varchar(255)    latin1_swedish_ci       No  None         Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext
    exam_name   varchar(255)    latin1_swedish_ci       No  None         Browse distinct values  Change  Drop    Primary     Unique  Index  Fulltext

Upvotes: 1

Views: 43

Answers (1)

CloudyMarble
CloudyMarble

Reputation: 37576

Use something like this:

INSERT INTO TABLE1(column1, column2, ... 
VALUES value_for_column1, value_for_column2, ...
WHERE NOT EXISTS (SELECT * FROM TABLE1 WHERE column1 = value_for_column1)

Upvotes: 1

Related Questions