Re: Urgent -Search column name by column number

[Paul Svirin]

Run this one (this is an example):

mysql> select column_name from INFORMATION_SCHEMA.columns WHERE table_schema='test' and table_name='tbl1' and ordinal_position=1;
+-------------+
| column_name |
+-------------+
| id |
+-------------+
1 row in set (0.01 sec)

Then read about dynamic SQL in MySQL at : http://rpbouman.blogspot.com/2005/11/mysql-5-prepared-statement-syntax-and.html

--------------
StarWind Software developer ( http://www.starwindsoftware.com )