Explain the MySQL cursor statements

What will be an ideal response?

The MySQL cursor statements include DECLARE CURSOR {CursorName} to define a cursor, OPEN {CursorName} to actually start the use of the cursor, and CLOSE {CursorName} to end the use of a cursor. While the cursor is running, the FETCH keyword is used to retrieve row data. A cursor is used with a looping structure of some sort, which can be created using the REPEAT and WHILE keywords.

Business

You might also like to view...

Quarterly sales is given for the past 3 years. Determine the seasonal factors for each quarter

Winter Spring Summer Fall Year 1 4800 4500 4100 5500 Year 2 5700 3800 4500 6000 Year 3 6000 4600 4900 6500

Business

In any organization, objectives are first needed at the top management level

a. True b. False Indicate whether the statement is true or false

Business