厭惡...
8月26日
今日又再次好忙, 本來精神的, 但是睇到另一些東西又變得超悶
早上一下唔記得叫人起身佢就遲到, 所以這是記性差的後果
原來自己做錯左咁多野, 唔諗番又唔係好覺... 以後真係要多留意
心散左好難集中, 成日好似有魔鬼係後面搞住我咁...
好討厭...
ps (DB Technical Section)
睇左一段講Phantom Reads (Records that appear in a set being read by another transaction)的文章, 個example幾好...
Transaction A begins.
SELECT * FROM employee WHERE salary > 30000
Transaction B begins.
INSERT INTO employee (empno, firstnme, midinit, lastname, job, salary) VALUES ('000350', 'NICK', 'A','GREEN','LEGAL COUNSEL',35000)
Transaction B inserts a row that would satisfy the query in Transaction A if it were issued again.
今日又再次好忙, 本來精神的, 但是睇到另一些東西又變得超悶
早上一下唔記得叫人起身佢就遲到, 所以這是記性差的後果
原來自己做錯左咁多野, 唔諗番又唔係好覺... 以後真係要多留意
心散左好難集中, 成日好似有魔鬼係後面搞住我咁...
好討厭...
ps (DB Technical Section)
睇左一段講Phantom Reads (Records that appear in a set being read by another transaction)的文章, 個example幾好...
Transaction A begins.
SELECT * FROM employee WHERE salary > 30000
Transaction B begins.
INSERT INTO employee (empno, firstnme, midinit, lastname, job, salary) VALUES ('000350', 'NICK', 'A','GREEN','LEGAL COUNSEL',35000)
Transaction B inserts a row that would satisfy the query in Transaction A if it were issued again.

0 Comments:
Post a Comment
<< Home