.D:\>netstat -h
显示协议统计信息和当前 TCP/IP 网络连接。
NETSTAT [-a] [-b] [-e] [-n] [-o] [-p proto] [-r] [-s] [-v] [interval]
发布者
Linux提取特定字符
cat maildress | cut -d\< -f2| cut -d\> -f1 > test.txt
cat test1 | grep “@163.com” > test2
用excel的高级筛选功能可以删除重复的行
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]