RE: Copying one table to another
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 another Say I have 2 tables with the exact same formatting (fields, values, etc.) Is there an easy way to dump the contents of one table to the other in SQL rather than outputting the one to a .txt or .sql and inputing it into the other table? Thanks, Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying one table to another
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 PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 8:49 PM Subject: Copying one table to another Say I have 2 tables with the exact same formatting (fields, values, etc.) Is there an easy way to dump the contents of one table to the other in SQL rather than outputting the one to a .txt or .sql and inputing it into the other table? Thanks, Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying a Table
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 mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Copying a Table
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 --- -Original Message- From: Shaun Bramley [mailto:[EMAIL PROTECTED]] Sent: 28 September 2002 17:19 To: [EMAIL PROTECTED] Subject: Copying a Table 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 mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying a Table
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 documentation. Is it possible to copy the contents of a table? If so how? Shaun mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copying a Table
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 like this - create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db` where 1 = 0 Hope It helps Insane http://www.webyog.com/sqlyog The definative GUI client for MySQL - Original Message - From: Shaun Bramley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 28, 2002 10:48 PM Subject: Copying a Table 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 mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Copying a table structure with constraints intact
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 copy with the structure? Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php