Re: Newbie Table question

2003-08-31 Thread Matt W
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 fro

Re: Newbie Table question

2003-08-31 Thread Eternal Designs, Inc
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 S

Newbie Table question

2003-08-29 Thread Tim Winters
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 PR

RE: Newbie table question

2002-04-04 Thread Gurhan Ozen
D] Subject: Newbie table question Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards,

RE: Newbie table question

2002-04-04 Thread Rick Emery
To: [EMAIL PROTECTED] Subject: Newbie table question Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please?

Newbie table question

2002-04-04 Thread Graham Nichols
Hi, I have a newbie question, to which my mysql books didn't have an answer! It is: I have two tables with identical structures. I wish to copy the data from table B into (append) table A. What sql statement will achieve this please? kind regards, Graham Nichols.