cat maildress | cut -d\< -f2| cut -d\> -f1 > test.txt
cat test1 | grep “@163.com” > test2
用excel的高级筛选功能可以删除重复的行
Linux提取特定字符
MYSQL中如何删除多个名字相似的表
.转载的：
#!/bin/sh
MYSQLBIN=”/usr/local/mysql/bin/mysql”
$MYSQLBIN -uroot -pxxx dbname -s -e “show tables like ‘NTSWKDVL_%’;” \
|sed ‘s/^/drop table /g’ |sed ‘s/$/;/g’ >/tmp/deletetable.sql
$MYSQLBIN -uroot -p123456 wordpress -s -e </tmp/deletetable.sql
$MYSQLBIN -uroot -p123456 wordpress -s -e </tmp/deletetable.sql
新版本中可能不需要-e参数
常用MySQL命令
关闭外键检查：
SET FOREIGN_KEY_CHECKS = 0
创建新用户
grant all on dbname.tablename to username@hostname identified by ‘password’;
一些MySQL的错误skip-name-resolve
[root@db1 ~]# service mysqld status
mysqld (pid 2965) is running…
[root@db1 ~]# service mysqld restart
Timeout error occurred trying to stop MySQL Daemon.
Stopping MySQL: [FAILED]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
酷Linux 专栏: Linux 和音乐潮流－1
喜欢看王小峰的博客，也喜欢听他博客上的歌，看到他博客上介绍这个可以下载他的歌曲就转了过来，原文不贴了
贴脚本
#!/usr/bin/python
# Download all the music recommended by wangxiaofeng.net
# Author: Eric You XU
# GPLv2
import os
import commands
os.popen("wget www.wangxiaofeng.net/mp3player.xml -O mp3player.xml")
str="""cat mp3player.xml|egrep -o path=[^3]+mp3|tr "\"" "\n"|grep http >wangxiaofeng.list"""
print str
os.popen(str)
f=open("wangxiaofeng.list")
for g in f.read().split('n'):
print g
a="wget ""+g+"""
os.popen(a)