To know the exit status of the elements of a pipeline cmd1 | cmd2 | cmd3 bash The exit codes are provided in the PIPESTATUS special array. cmd1 exit code is in ${PIPESTATUS[0]}, cmd3 exit code in ${PIPESTATUS[2]}, so that $? is always the same as ${PIPESTATUS: -1}. Read the rest of this entry
[Shell编程] awk 输出单引号双引号
2015.9 1
输出双引号 双引号中加反斜杠再加引号。 awk ‘{print “\””}’ 输出单引号：双引号中加双单引号，中间再加 反斜杠和单引号 awk ‘{print ” ‘ \’ ‘ “}’ Read the rest of this entry
[AMP] Mysql 导入导出csv
2015.8 28
导出csv select * from test_info into outfile ‘/tmp/test.csv’ fields terminated by ‘,’ optionally enclosed by ‘”‘ escaped by ‘”‘ lines terminated by ‘\n’; 导入csv load data local infile ‘/tmp/test.cs Read the rest of this entry
[AMP] Mysql 字符集设置
2015.8 28
MySQL字符集设置 • 系统变量： – character_set_server：默认的内部操作字符集 – character_set_client：客户端来源数据使用的字符集 – character_set_connection：连接层字符集 – character_set_results：查询结果字符集 – character_set_database：当 Read the rest of this entry
[AMP] mysqlimport: Error: 13, Can’t get stat of
2015.8 27
[root@sun ~]# mysqlimport –fields-terminated-by=, –lines-terminated-by=\n ziliao ./a.csv mysqlimport: Error: 13, Can’t get stat of ‘/var/lib/mysql/a.csv’ (Errcode: 2), when using table: a 缺少一个参数 –local · –local, -L Read input files Read the rest of this entry
