Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2015

    Unanswered: Mysql horizontal to vertical data

    Hi everyone,
    I'm new on this forum, and not very expert in mysql...
    Here's my question.

    I have a table like this:

    No code has to be inserted here.

    and would like to extract data this way:

    No code has to be inserted here.

    Hope I could explain.

    I tried with UNPIVOT but it does not allow it (I'm using Navicat 8), saying "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near UNPIVOT...".

    So I am short on options...

    Thanks for helping me!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59

    You are trying to unpivot the data. MySQL does not have an unpivot function
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts