V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
› 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 3418 days ago, the information mentioned may be changed or developed.
用 REPLACE INTO 的话是更新，有没有办法不影响原记录呢？
 |
1
julyclyde Dec 20, 2016
insert ignore?
|
 |
2
billlee Dec 20, 2016
那你为什么用 REPLACE 干嘛，用 INSERT
|
 |
3
north521 Dec 20, 2016
ON DUPLICATE KEY UPDATE
|
 |
4
inaho Dec 20, 2016
楼上+1 ， 加个唯一索引
|
 |
5
TaMud Dec 20, 2016
1 、唯一索引
2 、 WHERE NOT EXISTS |
 |
6
darrenfang Dec 21, 2016 via iPhone
insert ignore
|
 |
7
wwulfric Dec 21, 2016
唯一索引会报错啊
|
 |
8
Zuckonit Dec 21, 2016
1. mysql
2. unique index 3. ON DUPLICATE KEY UPDATE / INSERT IGNORE |
 |
9
anthow Dec 21, 2016
merge into ... when not matched then insert...
|
 |
10
ihuotui Dec 21, 2016
捕获唯一索引的错误，然后变为更新操作啊。
|
 |
11
rekulas Dec 21, 2016
insert into table1(a,b,c) select v1,v2,v3 from dual where not exists (select * from table1 where a='a')
这样也可以无重复插入 |
Select Language