Mysql：如果不存在则插入记录 [英] Mysql: insert record if not exists already

问题描述

大家好，我有视觉工作室2012 winform c＃



使用Mysql，我想插入记录，如果不存在于表格中



我尝试了什么：



INSERT INTO refreshcity（Id，Society）值（' 900000'，'toto'）

什么不存在（选择Id，社会从refreshcity WHERE Id ='900000'）

Hi all, i have visual studio 2012 winform c#

Using Mysql, i would like to insert record if not exists already in the table

What I have tried:

INSERT INTO refreshcity (Id, Society) values ('900000','toto')
WHERE NOT EXISTS (Select Id, Society From refreshcity WHERE Id ='900000')

推荐答案

阅读这个帖子，

MySQL：插入记录如果表中不存在 - Stack Overflow [ ^ ]

Read this thread,
MySQL: Insert record if not exists in table - Stack Overflow[^]

查询略有变化，只是尝试选择要在数据库中插入的记录，如果不是存在然后你可以插入其中。

见下面的片段

There is slight change in Query, Just try to select the record first which you want to insert in database, if it is not exist then you can insert in it.
see below snippet

INSERT INTO table_listnames (name, address, tele)
SELECT * FROM (SELECT 'name1', 'add', '022') AS tmp
WHERE NOT EXISTS (
    SELECT name FROM table_listnames WHERE name = 'name1'
) LIMIT 1;

希望有所帮助

Hope it helps

如果你有一个独特的列，你可以简单地插入忽略...;它将自动检查唯一列是否重复了要插入的每一行，如果已经存在，则将忽略该条目。

if you have an "unique" column you could simply do "insert ignore into... "; it will automatically check the unique column for duplicate an each row that is about to be inserted and will simply ignore an entry if already existing.

这篇关于Mysql：如果不存在则插入记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！