ROW
This page is part of MariaDB's Documentation.
The parent of this page is: Data Types for MariaDB Enterprise Server
Topics on this page:
Overview
This declaration is only available inside a stored procedure.
EXAMPLES
CREATE TABLE row_table(
descr VARCHAR(20),
val INT
);
INSERT INTO row_table VALUES ('Life', 42);
DELIMITER $$
CREATE PROCEDURE row_proc()
BEGIN
DECLARE rec1 ROW(descr VARCHAR(20), val INT);
SELECT * INTO rec1 FROM row_table;
SELECT rec1.descr, rec1.val;
END;
$$
DELIMITER ;
CALL row_proc();
+------------+----------+
| rec1.descr | rec1.val |
+------------+----------+
| Life | 42 |
+------------+----------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.