摘要:
1、注意:在同步之前一定要进行授权操作给从服务器grant all slave on *.* touser@192.168.1.2identified by 'pass'查看binlogshow master status;清除binlogreset master;2、一般主服务器进行 增、删、改,... 阅读全文
摘要:
set autocommit = 0;insert into t1(name) values ("user1");savepoint p1;insert into t1(name) values("user2");svaepoint p2;insert into t1(name) values("u... 阅读全文
摘要:
outfile 导出文件select name from t1 into outfile "/tmp/test.txt"infile 导入文件导入到表t1中的name列load data infile "/tmp/test.txt" into table t1(name);导入和导出的时候可以关闭索... 阅读全文