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 3426 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