用 REPLACE INTO 的话是更新，有没有办法不影响原记录呢？
› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
This topic created in 3605 days ago, the information mentioned may be changed or developed.
 |
julyclydeDec 20, 2016
1
insert ignore?
|
 |
billleeDec 20, 2016
2
那你为什么用 REPLACE 干嘛，用 INSERT
|
 |
north521Dec 20, 2016
3
ON DUPLICATE KEY UPDATE
|
 |
inahoDec 20, 2016
4
楼上+1 ， 加个唯一索引
|
 |
TaMudDec 20, 2016
5
1 、唯一索引
2 、 WHERE NOT EXISTS |
 |
darrenfangDec 21, 2016 via iPhone
6
insert ignore
|
 |
wwulfricDec 21, 2016
7
唯一索引会报错啊
|
 |
ZuckonitDec 21, 2016
8
1. mysql
2. unique index 3. ON DUPLICATE KEY UPDATE / INSERT IGNORE |
 |
anthowDec 21, 2016
9
merge into ... when not matched then insert...
|
 |
ihuotuiDec 21, 2016
10
捕获唯一索引的错误，然后变为更新操作啊。
|
 |
rekulasDec 21, 2016
11
insert into table1(a,b,c) select v1,v2,v3 from dual where not exists (select * from table1 where a='a')
这样也可以无重复插入 |
Select Language