Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "how to use mysql cursors". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "how to use mysql cursors" can help you solve the problem.

Description

1. The cursor is the data type used to store the query result set, and the cursor can be used to loop the result set in stored procedures and functions.

2. You can also call a cursor a cursor. The use of the cursor includes declaring the cursor, opening the cursor, using the cursor, and closing the cursor.

Example

-- query the data in the emp table through the stored procedure, and get the display create procedure pro_test11 () begin line by line-- declare the variable to be assigned declare e_id int (11); declare e_name varchar (50); declare e_age int (11); declare e_salary int (11);-- declare the cursor declare emp_result cursor for select * from emp;-- Open the cursor open emp_result -- fetch Vernier fetch emp_result into estrangidrect e-makeshift journal; select concat ('id=',e_id,', name=',e_name,', age=', e_age,', salary is:', e_salary); fetch emp_result into e-curiosity-- e-mai-nameje-recorder-- Select concat ('id=',e_id,', name=',e_name,', age=', e_age,', age=', e_age,', salary is:', e_salary); fetch emp_result into estrangement, name=',e_name,', age=', e_age,', salary is:', e_salary) Fetch emp_result into age=', e_age; select concat ('id=',e_id,', name=',e_name,', age=', e_age,', salary is:', e_salary);-- closing the cursor close emp_result; end$ on "how to use mysql cursors" ends here. Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.