experience

cmd下Oracle命令:
lsnrctl start
net start oracleserviceorcl
tnsping ORCL.CHINA

---------------------------------------------------
文本框中只输入数字：
onkeyup="this.value=this.value.replace(/\D/g,'')"
---------------------------------------------------
mysql导文件：
mysqlimport -pAdmin@123 dbname --fields-terminated-by=',' '/tmp/T_INTERNETUSERINFOSYNC_TMP.txt'
mysql -uroot -pAdmin@123 dbname < /root/hour.txt
--------------------------------------------------------
IP点阵式转整数：
SELECT * FROM TABLE WHERE ip= INET_ATON('222.244.230.17')
IP整数转点阵式：
SELECT * FROM TABLE WHERE ip= INET_NTOA(136524587)
--------------------------------------------------------
mysql load数据
LOAD DATA LOCAL INFILE 'E://cus.csv' INTO TABLE T_BIG_CUS FIELDS TERMINATED BY ',' (字段1,字段2)
---------------------------------------------------------
SHOW FULL PROCESSLIST
SHOW PROCESSLIST

远程拷贝：
scp root@128.20.59.6:/root/hour.txt /root/

jdk查看线程命令
jstack -l 4256

linux环境下添加路由：
查询路由信息：route
route add –net 128.18.0.0 255.255.0.0 MASK gw 128.20.0.0

window route add 128.18.38.0 mask 255.255.255.0 128.20.1.1
unix route add -net 128.18.38.0 netmask 255.255.255.0 gw 128.20.1.1

killall -9 httpd
统计进程数：
ps -ef | grep bin/httpd | wc -l

查看达到的并发数：
webbench -c 1000 -t 30 http://ip:8080/index.html

linux增加可执行权限：chmod +x jpda.sh

添加路由:
route print
route add 128.18.0.0 mask 255.255.0.0 128.20.1.1 -p

拷贝数据：
mysqldump -uroot -pAdmin@123 "--where=AREA_ID = 0 AND TYPE = 255" db_name T_TRAFFIC | mysql -uroot -pAdmin@123 -h128.20.20.103 db_name

unix时间：
SELECT UNIX_TIMESTAMP('2011-05-30 22:00:00')
SELECT FROM_UNIXTIME(1306892522)