If you are using mysql 5.x you must be able to retrieve that you want using information_schema database Look:
mysql> select version(); +-----------------+ | version() | +-----------------+ | 5.0.16-standard | +-----------------+ 1 row in set (0.00 sec) mysql> use information_schema; Database changed mysql> SELECT column_name,data_type FROM COLUMNS C where table_schema = 'erp' and table_name='TAnticipo'; +-------------------------+-----------+ | column_name | data_type | +-------------------------+-----------+ | idTAnticipo | int | | TEmpleado_idTEmpleado | int | | TViaje_idTViaje | int | | TTipoGasto_idTTipoGasto | int | | no_vale | char | | fecha | date | | tipo | char | | cantidad | tinyint | | importe | double | | iva | double | | observacion | char | | activo | char | +-------------------------+-----------+ 12 rows in set (0.01 sec) mysql> Regards! +----------------------------------------+ | ISC Edwin Cruz <[EMAIL PROTECTED]> | | Desk: 52 (449) 910 30 90 x3054 | | MX Mobile: 52 (449) 111 29 03 | | Skype: e-cruz | +----------------------------------------+ -----Mensaje original----- De: Mike OK [mailto:[EMAIL PROTECTED] Enviado el: Jueves, 19 de Enero de 2006 10:34 a.m. Para: mysql@lists.mysql.com Asunto: Show Description options?? Hi I was looking for a command that will list the names of my columns only. I have investigated show columns but there seems to be no way to return just the names. Any suggestions?? Thanks Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
