发布时间：2014-06-19 15:13:34
? MYSQL架构之MySQL Dual-Master双向同步.wiz-todo, .wiz-todo-img {width: 16px; height: 16px; cursor: default; padding: 0 10px 0 2px; vertical-align: -10%;-webkit-user-select: none;} .wiz-todo-label { display: inline-block; padding-top: 8px; padding-bottom: 8px; line-height: 1;} .wiz-todo-label-.........【阅读全文】
发布时间：2014-05-19 11:46:19
一、insert(增)1、将一个表的某些字段重新建为一个表insert into `tbnameA`(a,b,c) select a,b,c from `tbnameB`二、delete(删)1、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有rowid最小的记录delete from tbname where peopleId in (select peopleId from tbname group by peopleId.........【阅读全文】
