Hi, ----- Original Message ----- From: "Eternal Designs, Inc" Sent: Saturday, August 30, 2003 9:46 PM Subject: Re: Newbie Table question
> To copy table A to table B(non-existent) use this command: > > CREATE TABLE B SELECT * FROM A; > > Note. If your two tables are from different databases the syntax is > still the same. For instance if table A is in database Da and table B is > in database Db then use the MySQL command: > > CREATE TABLE Db.B SELECT * FROM Da.A; Note that this WILL NOT create B with the indexes that A has. So it's not an exact copy of the structure; just the data. If you want the indexes from A, you have to specify them in CREATE TABLE: CREATE TABLE b ( PRIMARY KEY (pri_key_from_a), KEY (other_key_col_from_a) -- etc. for any other keys from a ) SELECT * FROM a; > Peter K Aganyo > > > Tim Winters wrote: > > >Hi, > > > >How do you copy a table in mySQL. > > > >I know I can do it in phpMyAdmin but I want the actual syntax. > > > > > >Thanks!! > > > > > >Tim Winters > >Creative Development Manager > >Sampling Technologies Incorporated > > > >1600 Bedford Highway, Suite 212 > >Bedford, Nova Scotia > >B4A 1E8 > >www.samplingtechnologies.com > >[EMAIL PROTECTED] > >[EMAIL PROTECTED] > >Office: 902 450 5500 > >Cell: 902 430 8498 > >Fax:: 902 484 7115 > > > > > > -- > Peter K. Aganyo > Eternal Designs Inc., > +1(617)344-8023 (fax & voicemail) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]