Retrieve columns from a temp table with sql
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
Subject
Written By
Posted
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.