MySQL Forums
Forum List  »  Knowledge Base

Urgent -Search column name by column number
Posted by: suhas mahajan
Date: September 22, 2009 07:30AM

Hi All,
How do we get exact column name by giving its column number?

Scenario,
We need to find column name by its position number in table.

E.g. I have emp table having fields (eno, ename, addr, email)

Now I will put the condition in where clause ---

Where column_number=2;
then it should take the ename. and returns the value.


How can I achieve it.

Thank in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Urgent -Search column name by column number
5954
September 22, 2009 07:30AM


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.