On this page
ROW() function constructs a
RECORD object that may be used in an expression or assigned into a
RECORD type variable.
The following function creates a record value using
DELIMITER //CREATE FUNCTION f() RETURNS INT ASDECLAREr RECORD(a int, b int);BEGINr = ROW(1, 2);RETURN r.a + r.b;END //DELIMITER ;
Here’s an example use of this function:
+------+ | f() | +------+ | 3 | +------+
Type Inference The data types of the fields of the new
RECORD object created are inferred from the context of the function or stored procedure.
ROW() into a record variable, the types of the fields of the new record will be the same as the types of the fields of the record variable to which the new record value is assigned.
int based on the assignment to the variable
Last modified: May 22, 2023