create trigger sc_t
after update of grade on score
referencing
oldrow as oldtuple,
newrow as newtuple
for each row
when(newtuple.grade >= 1.1 * oldtuple.grade)
insert into sc_u(sno,cno,oldgrade,newgrade)
values(oldtuple.sno,oldtuple.cno,oldtuple.grade,newtuple.grade)
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'of grade on score
referencing
oldrow as oldtuple,
newrow as newtuple
' at line 2
> 時間: 0.011s
uj5u.com熱心網友回復：
我已經解決了轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/62212.html
標籤：其他技術專區
上一篇：哪位大神能幫我看看這段語音加密的代碼啊，跪求大神解惑！！
下一篇：棋牌游戲開發