|
|
Posted by E.T. Grey on 02/07/06 08:22
Hi All,
Despite spending the past six to seven hours perusing the docs on the
mySQl site, I still have questions unanswered, and have been unable to
get any help. I am familiar with Sybase, some Oracle and PostgreSQL -
but the mySQL SQL seems a bit "non-standard". I would be very grateful
for any help I get in answering these questions:
Stored procedures
==================
1). can a stored procedure return a data set (i.e. a recordset - one or
more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a stored procedure?
user defined functions (same questions as for stored procedures)
=======================================================
1). can a UDF return a data set (i.e. a recordset - one or more rows )?
2). if yes to question 1, how does one know how many rows were returned?
3). if yes to question 1, how does one access the fields (i.e. columns)
in the returned data ?
4). is it possible to declare an array type as a variable to use within
a UDF?
tia
Navigation:
[Reply to this message]
|