FreeBSD vi Replace

http://netlab.cse.yzu.edu.tw/~statue/freebsd/docs/aasir/ch062.pdf

http://note.tc.edu.tw/210.html

MySQL String Splitter

You can set up this example by running:

CREATE TABLE maintable (id INT, choices VARCHAR(255));
INSERT INTO maintable VALUES (1, 'red,green,blue,orange'), (2, 'blue'), (3, ''), (4, 'red,green');
CREATE TABLE othertable (id INT);
INSERT INTO othertable VALUES (1), (2), (3), (4), (5), (6), (7), (8);
You can add a grouping to the above SQL to get a statistical summary:

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(maintable.choices,',',othertable.id),',',-1) AS choice,
    COUNT(*) AS numtimes
FROM maintable INNER JOIN othertable ON
    (LENGTH(choices)>0 AND SUBSTRING_INDEX(SUBSTRING_INDEX(choices,',',othertable.id),',',-1)
    <> SUBSTRING_INDEX(SUBSTRING_INDEX(choices,',',othertable.id-1),',', -1))
GROUP BY choice ORDER BY choice;

http://www.tero.co.uk/scripts/mysql.php

Freebsd kill PID

ps auwx | grep 'mysql'

kill -9 PID

Emmet 進階的 zen coding

Goodbye Zen Coding~ Hello Emmet!

進階的zen coding

offical site
http://emmet.io/

sublime text plugin
https://sublime.wbond.net/packages/Emmet