I'd like to get the field names and data types of a table, say TableX, and
put it into TableDef using nothing but SQL. I know I can list the table
definition using "Describe Table" and then loop through the results and
insert the first two columns Field and Type into TableDef, but is there a
way to do it using just SQL?
Example:
Describe TableX:
First_Name Char(15) ....
Last_Name Char(20) ...
Start_Date Date ..
Salary Double ..
And I'd like TableDef to have these rows:
ColName ColType
--------------- --------------
First_Name Char(15)
Last_Name Char(20)
Start_Date Date
Salary Double
Is there a way to do this with one SQL statement? I'm really looking for
the MySQL internal table where it stores the table definitions.
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org