PIVOT AND UNPIVOT
HELP WITH SYNTAX FOR PIVOT AND UNPIVOT OPERATORS.
Answer Answered by Ian Gilfillan in this comment.
To combine the two comments into one answer:
- The CONNECT storage engine has a pivot table type. See CONNECT PIVOT Table Type.
- There's a workaround for the main server described at Pivoting in MariaDB.
- There's a feature request for pivot at MDEV-10144.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.