Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Retrieve MYSQL Table Structure

hhcamiglahhcamigla Member Posts: 31
I am using Delphi 6,MySQL ODBC 3.51 Driver,TADOQuery and MySQL as my Database.
How can I retrieve the sturcture of my tables in for ff format.

[Field Name][Type]

ITE_CODE Char(14)
ITE_DESC Char(40)

I have an existing table called MITEMS
I already used the commands like
DESC MITEMS
SHOW COLUMNS FROM MITEMS

But it always raise an exception
Sign In or Register to comment.