Ed,
You could use the insert .. select syntax.
See: http://www.mysql.com/doc/en/INSERT_SELECT.html
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:ed;home.homes2see.com]
Sent: Thursday, 14 November 2002 18:50
To: [EMAIL PROTECTED]
Subject: Copying one table to
Hi,
You can use :
INSERT INTO SELECT * FROM YOUR_TABLE
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: [EMAIL
Check out
http://www.mysql.com/doc/en/mysqldump.html that should help you.
John Coder
On Sat, 2002-09-28 at 13:18, Shaun Bramley wrote:
Hello all,
I have yet to find this bit of information within the documentation. Is it
possible to copy the contents of a table? If so how?
Shaun
select * from table1 insert into table2
both tables need the same structure
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
To where? Another table? More information is required.
- Original Message -
From: Shaun Bramley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 28, 2002 1:18 PM
Subject: Copying a Table
Hello all,
I have yet to find this bit of information within the
Greetings...
It is possible. Say for eg. If you want to copy the structure and data of
the db table in mysql table. you can use the following statement -
create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db`
If you cant to copy only the structure then you can use a query
Hi There;
I have some template tables in my SQL database that I was hoping to copy to
make
the production tables, but I have noticed that the constraints do not copy
when I create the production table using a select statement. Dows anyone
know of a way to copy the table and have the constraints