MySQL Forums
Forum List  »  MySQL Query Browser

Retrieve columns from a temp table with sql
Posted by: Victor Otazu
Date: January 06, 2012 10:34AM

Hi everyone! It's my first post here.

I have some expertise with MSSQL, but I'm new with MySql. I wanted to know if there is a way to get the column names from a temporary table created on a sproc using sql code for that. I know that it's easier with PHP or another language, but I'm a kind of obsessed with doing that with sql code.

What I want to do is to create sql code to build (dinamically) an unpivoted version of a dataset returned by a stored procedure.

Thanks in advance for your help!!

BTW I'm using MySQl 5

Options: ReplyQuote

Written By
Retrieve columns from a temp table with sql
January 06, 2012 10:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.