vi替换实例的练习

原创

Mengix 2015-06-25 10:20:42 博主文章分类：Linux ©著作权

文章标签 vi 文章分类 MySQL 数据库

©著作权归作者所有：来自51CTO博客作者Mengix的原创作品，请联系作者获取转载授权，否则将追究法律责任

多行mysql的代码要进行批量添加
mysql> INSERT INTO y2k VALUES ("1998-12-31","1998-12-31 23:59:59",19981231235959);
mysql> INSERT INTO y2k VALUES ("1999-01-01","1999-01-01 00:00:00",19990101000000);
mysql> INSERT INTO y2k VALUES ("2000-02-29","2000-02-29 00:00:00",20000229000000);
。。。。。。
。。。。。。
。。。。。。

替换掉mysql>

1. 单行替换 （:s/替换前字段/替换后字段/g）
:s/mysql>//g

结果：
mysql> INSERT INTO y2k VALUES ("1998-12-31","1998-12-31 23:59:59",19981231235959);
mysql> INSERT INTO y2k VALUES ("1999-01-01","1999-01-01 00:00:00",19990101000000);
INSERT INTO y2k VALUES ("2000-02-29","2000-02-29 00:00:00",20000229000000);

2. 全局替换 （:%s/替换前字段/替换后字段/g）

:%s/mysql>//g

结果：
INSERT INTO y2k VALUES ("1998-12-31","1998-12-31 23:59:59",19981231235959);
INSERT INTO y2k VALUES ("1999-01-01","1999-01-01 00:00:00",19990101000000);
INSERT INTO y2k VALUES ("2000-02-29","2000-02-29 00:00:00",20000229000000);

为了整齐一些去掉行前空格

:%s/ //

结果：
INSERT INTO y2k VALUES ("1998-12-31","1998-12-31 23:59:59",19981231235959);
INSERT INTO y2k VALUES ("1999-01-01","1999-01-01 00:00:00",19990101000000);
INSERT INTO y2k VALUES ("2000-02-29","2000-02-29 00:00:00",20000229000000);

HR要求：去掉所有的空格 (末尾加g)
:%s/ //g

结果：
INSERTINTOy2kVALUES("2000-02-29","2000-02-29 00:00:00",20000229000000);

3.带/的替换
将/usr/local/mysql替换为/etc/my.cnf

:s+/usr/local/mysql+/etc/my.cnf

4.#代替/进行替换
将etc换成opt
:s#etc/#opt/#

总结：
行首%为全列替换（等同于行首的g/替换前字段/s//替换后字段/）
:%s/aaa/bbb/g