itomg

var str = 'asdfasflasjfasjfasfapple;asdfasfasfas';
var keyword = 'apple';
if(str.search(new RegExp(keyword, 'i')) == -1){
   alert('Found ' + keyword);
}

itomg

select substring_index(substring(field_name, instr(field_name, "@")+1), " ", 1)

itomg

cd ~/www/albicilla/api
forever start -l ~/.forever/api.log -e ~/.forever/err.api.log -w -a app.js
cd ~/www/albicilla/public
forever start -l ~/.forever/public.log -e ~/.forever/err.public.log -w -a app.js

itomg

#分析日志中的UserAgent
cat access_20130704.log | awk -F "\"" '{print $(NF-3)}' | sort | uniq -c | sort -nr | head -20
#上面的脚本将分析出日志文件中最多的20个UserAgent

#分析日志中那些IP访问最多
cat access_20130704.log | awk '{print $1}' | sort | uniq -c | sort -nr | head -20

#分析日志中那些Url请求访问次数最多
cat access_20130704.log | awk -F "\"" '{print $(NF-5)}' | sort | uniq -c | sort -nr | head -20 

itomg

pt-query-digest slow.log > digest.log

itomg

select column_name from information_schema.columns where TABLE_NAME = 'your table name' order by ordinal_position;

itomg

## Linux
stat -c %a [file or directory path]

## Mac OS X
stat -f "%Lp" [filename]

itomg

# login to mysql client as root
GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'localhost' IDENTIFIED BY '[password]' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO '[user name]'@'%' IDENTIFIED BY '[password]' WITH GRANT OPTION;

itomg

SELECT `ENGINE` FROM `information_schema`.`TABLES` WHERE `TABLE_SCHEMA`='your_database_name' AND `TABLE_NAME`='your_table_name';

itomg

npm update npm -g