> Is there a way to select/query the table structure and get a recordset
> with the results?
> Something like:
> "Id", int, not null, autoincrement
> name, varchar(20), not null
SHOW COLUMNS FROM
or even
DESCRIBE
These commands return recordsets exatly line SELECT commands.
Alec
--
> Is there a way to select/query the table structure and get a recordset
> with the results?
> Something like:
> "Id", int, not null, autoincrement
> name, varchar(20), not null
DESC table_name
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
gt meddelande-
> Från: Gjoko Jovanovski [mailto:[EMAIL PROTECTED]
> Skickat: den 22 oktober 2003 15:10
> Till: [EMAIL PROTECTED]
> Ämne: selecting table structure
>
>
> Is there a way to select/query the table structure and get a
> recordset with the results? S
Is there a way to select/query the table structure and get a recordset
with the results?
Something like:
"Id", int, not null, autoincrement
name, varchar(20), not null
Thanks,
Gjoko.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my