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.
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
In any organization, objectives are first needed at the top management level
a. True b. False Indicate whether the statement is true or false