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

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

Add a comment
prosam056
By:
prosam056

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

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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help