Related

Product Now Available: Managed MySQL Databases Product
How to Import large Mysql databases into a small droplet. Question Question
PHP Error Log: authz_core:error - For files that don't exists on my server Question Question

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.8k views
MySQLLinux CommandsUbuntu 16.04

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

Add a comment
prosam056
By:
prosam056
Add a comment

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
hansen May 11, 2017

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/

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help