create table TableDEF like TableX; Or am I missing something ??
On Tue, May 11, 2010 at 11:36 AM, mos <mo...@fastmail.fm> wrote: > 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=pchap...@nc.rr.com > > -- Distributed Computing stats http://stats.free-dc.org
