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
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
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
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,
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?
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.