Select*fromStudent_info;+-----+--------+---- ----------------------+----------------+|id |Nama |Alamat |Subjek |+-----+-------- -+-- ----------+-----"/> Select*fromStudent_info;+-----+--------+---- ----------------------+----------------+|id |Nama |Alamat |Subjek |+-----+-------- -+-- ----------+-----">
Rumah > Artikel > pangkalan data > Cipta prosedur tersimpan MySQL untuk mendapatkan baris daripada jadual menggunakan kursor?
Berikut ialah prosedur tersimpan yang mengambil rekod daripada lajur nama jadual "student_info" yang mempunyai data berikut -
mysql> Select * from Student_info; +-----+---------+------------+------------+ | id | Name | Address | Subject | +-----+---------+------------+------------+ | 101 | YashPal | Amritsar | History | | 105 | Gaurav | Chandigarh | Literature | | 125 | Raman | Shimla | Computers | | 127 | Ram | Jhansi | Computers | +-----+---------+------------+------------+ 4 rows in set (0.00 sec) mysql> Delimiter // mysql> CREATE PROCEDURE cursor_defined(OUT val VARCHAR(20)) -> BEGIN -> DECLARE a,b VARCHAR(20); -> DECLARE cur_1 CURSOR for SELECT Name from student_info; -> DECLARE CONTINUE HANDLER FOR NOT FOUND -> SET b = 1; -> OPEN CUR_1; -> REPEAT -> FETCH CUR_1 INTO a; -> UNTIL b = 1 -> END REPEAT; -> CLOSE CUR_1; -> SET val = a; -> END// Query OK, 0 rows affected (0.04 sec) mysql> Delimiter ; mysql> Call cursor_defined2(@val); Query OK, 0 rows affected (0.11 sec) mysql> Select @val; +------+ | @val | +------+ | Ram | +------+ 1 row in set (0.00 sec)
Daripada set hasil di atas, kita dapat melihat bahawa nilai parameter val ialah "Ram ", Kerana ia adalah nilai terakhir lajur "Nama".
Atas ialah kandungan terperinci Cipta prosedur tersimpan MySQL untuk mendapatkan baris daripada jadual menggunakan kursor?. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!