CODEWITHSUNDEEP
mysqldatabase-cursor
sagar
sagar

Reputation:

Return Cursor from Stored Procedure

How can I return a cursor from stored procedure in MySQL?

Upvotes: 4

Views: 1892

Answers (3)

longneck
longneck

Reputation: 12226

mysql doesn't support client-side cursors. they exist ONLY in stored procedures.

Upvotes: -1

KV Prajapati
KV Prajapati

Reputation: 94645

A cursor is a server side thing. You can't "return" this to a client.

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300529

Simply: Don't do it!

Seriously: it's an indication that your design is flawed.

Upvotes: 2

Related Questions