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

Comments

  • Justin BibJustin Bib USAMember Posts: 0

    ______ < http://forcoder.org /> free ebooks and video tutorials about { Python Visual Basic Delphi C C# PHP Objective-C Java Swift JavaScript Perl C++ R MATLAB Visual Basic .NET Go Ruby Scratch PL/SQL Assembly ML Ada Prolog F# Hack Transact-SQL Awk Lisp Logo SAS Fortran COBOL Lua D Alice LabVIEW Rust Kotlin Bash Julia FoxPro Apex Erlang Scala VBScript Scheme ABAP Clojure Crystal Dart } ____________

Sign In or Register to comment.