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 Graham,
You can just use "INSERT INTO ... SELECT ..." statement for it . See the
manual:
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
Gurhan
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: New
delete from tableB;
INSERT INTO tableB SELECT * FROM tableeA;
see manual:
6.4.3.1 INSERT ... SELECT Syntax
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
-Original Message-
From: Graham Nichols [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:44 AM
T
