Month: October 2008
mysql 一個特別的 delete command
delete tbl_item_fetch_img a
from tbl_item_fetch_img a,tbl_item b
where a.hid = b.hid and b.company = ‘CTC’
Oracle trigger sample
CREATE OR REPLACE TRIGGER SET_items_LSUPDATE AFTER INSERT OR UPDATE ON items_FILE REFERENCING NEW AS New OLD AS Old FOR EACH ROW DECLARE OLDG_NO NUMBER(14); BEGIN SELECT COUNT(*) INTO OLDG_NO FROM BIDLEADER.items_LASTUPDATE WHERE G_NO=:Old.G_NO; IF OLDG_NO >= 1 THEN UPDATE BIDLEADER.items_LASTUPDATE SET G_LASTUPDATE=SYSDATE WHERE G_NO=:Old.G_NO; ELSIF OLDG_NO=0 THEN INSERT INTO BIDLEADER.items_LASTUPDATE VALUES (:New.G_NO, SYSDATE); END IF; END SET_items_LSUPDATE;
linux / putty ssh tunnel setting
在 HOST A 下
# # ssh -D 8000 -C -N -f [email protected] #
-D bind 一個 “dynamic” 的port ,
-C 壓縮 ,
-N 不執行任何 command ,
-f 背景執行,
在 HOST A 下 netstat -an | grep LIST 可以看到
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN
若本機為 linux , dynanic 的連法:
ssh -NfD 8000 -p 2200 [email protected]
— 在本機建立一個 port 8000 的 listen 透過 ssh 連到 safe.server.tw 的 ssh port 2200 去.
// ——
screen :
http://digitalpbk.blogspot.com/2009/05/ssh-proxy-windows-linux-orkut-bypass.html