Generating SQL code?

2002-02-19 Thread Sterling J. Anderson
I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks.

Re: Generating SQL code?

2002-02-19 Thread Varshavchick Alexander
PROTECTED] Subject: Generating SQL code? I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything

Re: Generating SQL code?

2002-02-19 Thread John Cichy
Take a look at mysqldump John On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie.

Re: Generating SQL code?

2002-02-19 Thread Paul DuBois
At 11:14 -0600 2/19/02, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not