One other question. I'm trying to see if I can get an application written in ColdFusion and using MyODBC to execute SHOW CREATE TABLE statements. The problem I'm having, though is that I can't figure out how to get CF to refence a column name containing a space. Is there any way to alias the name of the 'CREATE TABLE' column that is returned?
SHOW CREATE TABLE mytable ----- Original Message ----- From: "Jackson Miller" <[EMAIL PROTECTED]> To: "Jim McAtee" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 9:42 PM Subject: Re: How to export db or table structure? > mysqldump --opt > > -Jackson > > > On Friday 25 July 2003 10:39, Jim McAtee wrote: > > > We have a very large MySQL database, and the designer of the database no > > > longer works for us. I need to re-create the same table structure, but > > > without the content, on a separate machine. > > > > > > I know I can do a show tables on the existing db, and also a describe on > > > those tables, so I know what the table structure looks like. I am trying > > > to avoid having to re-type the create table statements for each table. > > > > SHOW CREATE TABLE tablename; > > > > This can also easily be done from the MySQL Control Console. Tools > Show > > Create > Execute will generate the necesary CREATE TABLE statement. > > > > A question for anyone else: Is there a means of using SHOW CREATE TABLE > > that will return CREATE TABLE statements for every table within a database? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]