MySQL Forums :: Stored Procedures :: Create cursor from string
Create cursor from string
Posted by: P B ()
Date: November 06, 2009 08:01AM
In PostgreSQL it is possible:
OPEN curs1 FOR EXECUTE 'SELECT * FROM ' || quote_ident($1);
http://www.postgresql.org/docs/8.2/static/plpgsql-cursors.html
Is there possible this feture in MySQL?
OPEN curs1 FOR EXECUTE 'SELECT * FROM ' || quote_ident($1);
http://www.postgresql.org/docs/8.2/static/plpgsql-cursors.html
Is there possible this feture in MySQL?
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Create cursor from string | 206 | P B | 11/06/2009 08:01AM |
| Re: Create cursor from string | 125 | ashr ben | 11/06/2009 11:02AM |
Sorry, only registered users may post in this forum.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.