Home Database Mysql Tutorial MYSQL插入数据时忽略重复数据_MySQL

MYSQL插入数据时忽略重复数据_MySQL

Jun 01, 2016 pm 01:29 PM
insert program

bitsCN.com

MYSQL插入数据时忽略重复数据

 

当程序中insert时,已存在的数据不插入,不存在的数据insert。在网上搜了下,

可以使用存储过程或者是用NOT EXISTS 来判断是否存在。

使用下以两种方法时必须把字段设为”主键(PRIMARY KEY”或”唯一约束(UNIQUE)”。

 

1:使用REPLACE INTO (此种方法是利用替换的方法,有点似类于先删除再插入) REPLACE INTO Syntax REPLACE [LOW_PRIORITY | DELAYED]     [INTO] tbl_name [(col_name,...)]     {VALUES | VALUE} ({expr | DEFAULT},…),(…),… Or: REPLACE [LOW_PRIORITY | DELAYED]     [INTO] tbl_name     SET col_name={expr | DEFAULT}, … Or: REPLACE [LOW_PRIORITY | DELAYED]     [INTO] tbl_name [(col_name,...)]     SELECT …2:使用INSERT [IGNORE] INTO (此种方法效率比较高,判断是否存在,存在不插入,否则插入) INSERT [IGNORE] INTO Syntax INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [(col_name,...)] {VALUES | VALUE} ({expr [...]
Copy after login

 


bitsCN.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to make Google Maps the default map in iPhone How to make Google Maps the default map in iPhone Apr 17, 2024 pm 07:34 PM

How to make Google Maps the default map in iPhone

Fix: Operator denied request error in Windows Task Scheduler Fix: Operator denied request error in Windows Task Scheduler Aug 01, 2023 pm 08:43 PM

Fix: Operator denied request error in Windows Task Scheduler

How to sort photos by face on Windows 10 and 11 How to sort photos by face on Windows 10 and 11 Aug 08, 2023 pm 10:41 PM

How to sort photos by face on Windows 10 and 11

How to write a simple countdown program in C++? How to write a simple countdown program in C++? Nov 03, 2023 pm 01:39 PM

How to write a simple countdown program in C++?

Clock app missing in iPhone: How to fix it Clock app missing in iPhone: How to fix it May 03, 2024 pm 09:19 PM

Clock app missing in iPhone: How to fix it

How to open a website using Task Scheduler How to open a website using Task Scheduler Oct 02, 2023 pm 11:13 PM

How to open a website using Task Scheduler

iOS 17: How to organize iMessage apps in Messages iOS 17: How to organize iMessage apps in Messages Sep 18, 2023 pm 05:25 PM

iOS 17: How to organize iMessage apps in Messages

How to quickly uninstall apps from the Microsoft Store How to quickly uninstall apps from the Microsoft Store Jul 12, 2023 pm 09:25 PM

How to quickly uninstall apps from the Microsoft Store

See all articles