Next Question

Answered Question

phpcook

December 23, 2008 12:36 PM

Hi experts please explain how mysql triggers&cursors works?

Hi experts could you explain more information about Mysql Triggers & Cursors

Interesting Question? Yes (0) No (0)

RSS

Best Answer Chosen by Asker

pvera

December 23, 2008 01:03 PM

Straight from the horses's mouth:

http://dev.mysql.com/doc/refman/5.0/en/triggers.html
http://dev.mysql.com/doc/refman/5.0/en/cursors.html

I don't know the specifics for MyQL, but in both SQL Server and Oracle a trigger is simply a command that is executed whenever an INSERT/UPDATE/DELETE (you can pick which of these three apply to the trigger, it doesn't need to use all three) happens against the target table and a cursor is a temporary recordset that you use within a stored procedure.

Helpful Answer?

(1)

(0) Tip pvera for this answer

Permalink | Report

Answer this Question

Ask a Question

Top of Page

Buy Mahalo Dollars with Credit Card or PayPal

Top Members

This Week All Time

buddawiggi
2nd Degree Black Belt
25027 Points
M$701.03 Earned
cfinke
2nd Degree Black Belt
23219 Points
M$29.75 Earned
unwirklich
Purple Belt
2323 Points
M$131.55 Earned

See All

Most Popular Tags

mahalo(1398)

twitter(923)

iphone(449)

music(435)

google(324)

food(290)

internet(283)

beer(267)

online(266)

money(246)

apple(239)

movies(235)

aotd(233)

facebook(228)

answers(203)

video(197)

health(197)

free(190)

windows(190)

dog(188)

See All

Welcome New Members

achayan, November 11, 2009 05:27 PM
conundrum_nyarl..., November 11, 2009 05:21 PM
yuki0, November 11, 2009 05:10 PM
ngettman, November 11, 2009 05:09 PM
michaelus, November 11, 2009 05:06 PM

Mahalo Dollars are the currency of Mahalo Answers.

Each Mahalo Dollar costs $1.

Once you earn more than 40 Mahalo Dollars, you can request to be paid via PayPal. Each Mahalo Dollar is currently worth $0.75 when paid out via PayPal. Learn More