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

May 11, 2017 1.5k views
Ubuntu 16.04 Linux Commands MySQL

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

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/

Have another answer? Share your knowledge.