Question

I can't use pivot command in mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64) using EditLine wrapper.

Posted May 11, 2017 1.6k views
MySQL Linux Commands Ubuntu 16.04

Syntax Error.
How to use mysql pivot command in above linux distro.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

1 answer

Hi @prosam056
I don’t understand most of the header line, but MySQL doesn’t have a pivot function.
Read more here to find ways to create pivoting:
http://modern-sql.com/use-case/pivot
https://mariadb.com/kb/en/mariadb/pivoting-in-mariadb/

Submit an Answer