mysql - 忽略重复项并在 mysql 中插入新记录

Question

我有一个表名类(class)。它包含以下数据:

mca
bca
msc
me

现在，当我一次输入 2 个值时，mca mtech。它应该接受 mtech 并忽略 mca。请任何人帮忙解决。

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

Answer 1

使用这样的东西:

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