MySQL Cursor

<< Back to MYSQL

next → ← prev MySQL Cursor In MySQL, Cursor can also be created. Following are the steps for creating a cursor. 1. Declare Cursor A cursor is a select statement, defined in the declaration section in MySQL. Syntax DECLARE cursor_name CURSOR FOR Select statement; Parameter: cursor_name: name of the cursor select_statement: select query associated with the cursor 2. Open Cursor After declaring the cursor the next step is to open the cursor using open statement. Syntax Open cursor_name; Parameter: cursor_name: name of the cursor which is already declared. 3. Fetch Cursor After declaring and opening the cursor, the next step is to fetch the cursor. It is used to fetch the row or the column. Syntax FETCH [ NEXT [ FROM ] ] cursor_name INTO variable_list; Parameter: cursor_name: name of the cursor variable_list: variables, comma separated, etc. is stored in a cursor for the result set 4. Close Cursor The final step is to close the cursor. Syntax Close cursor_name; Parameter: Cursor_name: name of the cursor Example for the cursor: Step 1: Open the database and table. Step 2: Now create the cursor. Query: Step 3: Now call the cursor. Query: SET @name_list =""; CALL list_name(@name_list); SELECT @name_list; Next TopicMySQL limit ← prev next →

Related Links:

• MySQL Create Database
• MySQL DAYOFWEEK() Function
• MySQL DAYOFYEAR() Function
• MySQL From_days() Function
• MySQL Hour() Function
• MySQL ADDTIME() Function
• MySQL CURRENT_TIME() Function
• MySQL CURRENT_TIMESTAMP() Function
• MySQL last_day() Function
• MySQL localtime() Function
• MySQL localtimestamp() Function
• MySQL makedate() Function
• MySQL maketime() Function
• MySQL microsecond() Function
• MySQL minute() Function
• MySQL month() Function
• MySQL vs SQL
• MySQL monthname() Function
• MySQL now() Function
• MySQL period_add() Function
• MySQL period_diff() Function
• MySQL quarter() Function
• MySQL sec_to_time() Function
• MySQL Sysdate() Function
• MySQL second() Function
• MySQL Subdate() Function
• MySQL Subtime() Function
• MySQL time() Function
• MySQL time_to_sec() Function
• MySQL time_format() Function
• MySQL to_day() Function
• MySQL timediff() Function
• MySQL timestamp() Function
• MySQL weekday() Function
• MySQL Math SIN() Function
• MySQL week() Function
• MySQL weekofyear() Function
• MySQL Math
• MySQL Math ABS() Function
• MySQL Math ACOS() Function
• MySQL Math SIGN() Function
• MySQL Math SQRT() Function
• MySQL Math SUM() Function
• MySQL Math TAN() Function
• MySQL Math ATAN2() Function
• MySQL Drop Table
• MySQL View
• MySQL Queries
• MySQL Insert Statement
• MySQL Update Statement
• MySQL Math TRUNCATE() Function
• MySQL Math ASIN() Function
• MySQL Math ATAN() Function
• MySQL Math MIN() Function
• MySQL Math AVG() Function
• MySQL Math CEIL() Function
• MySQL Math CEILING() Function
• MySQL Math COS() Function
• MySQL Math COT() Function
• MySQL Math COUNT() Function
• MySQL Math DEGREES() Function
• MySQL Math DIV() Function
• MySQL Math EXP() Function
• MySQL Math FLOOR() Function
• MySQL Math GREATEST() Function
• MySQL Math LEAST() Function
• MySQL Math LN() Function
• MySQL Math LOG10() Function
• MySQL Math LOG() Function
• MySQL Math LOG2() Function
• MySQL Math MAX() Function
• MySQL Math MOD() Function
• Learn MySQL Tutorial
• MySQL Math PI() Function
• MySQL Math POWER() Function
• MySQL Math POW() Function
• MySQL Math RADIANS() Function
• MySQL Math RAND() Function
• MySQL Math ROUND() Function
• MySQL String
• MySQL String CONCAT_WS() Function
• MySQL String CHARACTER_LENGTH() Function
• MySQL String CONCAT() Function
• MySQL String ELT() Function
• MySQL String EXPORT_SET() Function
• MySQL String RTRIM() Function
• MySQL String FIELD() Function
• MySQL String FIND_IN_SET() Function
• MySQL String FORMAT() Function
• MySQL String FROM_BASE64() Function
• MySQL String HEX() Function
• MySQL String INSERT() Function
• MySQL String INSTR() Function
• MySQL String LCASE() Function
• MySQL String LEFT() Function
• MySQL String LENGTH() Function
• MySQL String like() Function
• MySQL String LOAD_FILE() Function
• MySQL String LOCATE() Function
• MySQL String LOWER() Function
• MySQL String LPAD() Function
• MySQL String LTRIM() Function
• MySQL String MAKE_SET() Function
• MySQL String MID() Function
• MySQL String OCTET_LENGTH() Function
• MySQL String OCT() Function
• MySQL String ORD() Function
• MySQL String POSITION() Function
• MySQL String QUOTE() Function
• MySQL String REPEAT() Function
• MySQL String REPLACE() Function
• MySQL String REVERSE() Function
• MySQL String SPACE() Function
• MySQL String RIGHT() Function
• MySQL String RPAD() Function
• MySQL String SOUNDEX() Function
• MySQL String UNHEX() Function
• MySQL String UCASE() Function
• MySQL String STRCMP() Function
• MySQL String SUBSTR() Function
• MySQL String SUBSTRING_INDEX() Function
• MySQL String SUBSTRING() Function
• MySQL String Trim() Function
• MySQL String UPPER() Function
• MySQL Drop Database
• MySQL Create Table
• MySQL Alter Table
• MySQL Truncate Table
• MySQL Delete Statement
• MySQL Select Statement
• MySQL Group By Clause
• Top 58 MySql Interview Questions (2021)
• MySQL Features
• MySQL Data Types
• MySQL regexp_like() function
• MySQL regexp_replace() Function
• MySQL regexp_substr() function
• MySQL Select Database
• MySQL Where Clause
• MySQL Distinct Clause
• MySQL From Clause
• MySQL Order By Clause
• MySQL Having Clause
• MySQL AND Condition
• MySQL average()
• MySQL min()
• MySQL max()
• MySQL Literals
• MySQL OR Condition
• MySQL AND and OR Condition
• MySQL IS NULL Condition
• MySQL LIKE Condition
• MySQL IN Condition
• MySQL NOT Condition
• MySQL IS NOT NULL Condition
• MySQL first()
• MySQL BETWEEN Condition
• MySQL Join
• MySQL count()
• MySQL sum()
• MySQL last()
• MySQL Comments
• MySQL not regexp Operator
• MySQL Regexp Operator
• MySQL regexp_instr() function
• MySQL Cursor
• MySQL Functions
• MySQL Date and Time
• MySQL PROCEDURE
• MySQL Trigger
• MySQL not like Operator
• MySQL date/time
• MySQL DATE() Function
• MySQL DATE_ADD() Function
• MySQL ADDDATE() Function
• MySQL CURDATE() Function
• MySQL CURRENT_DATE() Function
• MySQL DATE_FORMAT() Function
• MySQL DATEDIFF() Function
• MySQL DAY() Function
• MySQL CURTIME() Function
• MySQL DAYNAME() Function
• MySQL DAYOFMONTH() Function
• MySQL str_to_date() Function

Related Links