Hi Peter (and MySQL list),
On Wed, Jan 13, 2010 I (Ricardo Dias Marques) asked the following :
It would be convenient for me to get a list of those fields ordered by
field / column name.
... and on the same day, Peter Brawley peter.braw...@earthlink.net
kindly replied:
SELECT *
FROM
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that server, I have a database that has a table with many fields (around 60).
It would be convenient for me to get a list of those fields ordered by
field / column name. Unfortunately, a DESC tablename (DESCRIBE
tablename)
It would be convenient for me to get a list of those fields ordered by
field / column name.
SELECT *
FROM information_schema.columns
WHERE table_schema='db' AND table_name='tbl';
PB
-
Ricardo Dias Marques wrote:
Hi all,
I have a Linux server with MySQL 5.0 (5.0.67) installed.
In that