Re: Copy database question
* Tom Nickels > I have "Database 1", table "userdata", field "username" > > I need to copy the above mentioned data to: > > "Database2", Table "chat_data", field "nick" > > I have no clue how to do it! Can anybody tell me the string? If the destination table already exist, something like this: INSERT INTO Database2.chat_data SELECT username AS nick FROM `Database 1`.userdata http://www.mysql.com/doc/en/INSERT_SELECT.html > Note the backticks used for the database name containing a space: http://www.mysql.com/doc/en/Legal_names.html > -- Roger - 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: Copy database question
Tom, > I have "Database 1", table "userdata", field "username" > I need to copy the above mentioned data to: > "Database2", Table "chat_data", field "nick" in phpMyAdmin 2.3.3pl1 you can accomplish this as follows: 1. Choose "Database 1" in the left frame. 2. Click table "userdata" in the left frame. 3. Click the "Operations" tab in the right frame. 4. Choose "Copy table to (database.table)" in the right frame. 5. Choose "Database 2" (must exist), fill in "chat_data", choose "Structure and data". Klick "Go". 6. Choose "Database 2" and then "chat_data" in the left frame. 7. Click the "Structure" tab in the right frame. 8. For column "username", click "Change", fill in "nick", click "Save". Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Tom Nickels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 1:23 PM Subject: Copy database question > Hi everybody, > > I am new on mysql. I use phpadmin for adminstration. > > My problem: > > I have "Database 1", table "userdata", field "username" > > I need to copy the above mentioned data to: > > "Database2", Table "chat_data", field "nick" > > I have no clue how to do it! Can anybody tell me the string? Thanks for > help! > > Tom > > > - > 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
Copy database question
Hi everybody, I am new on mysql. I use phpadmin for adminstration. My problem: I have "Database 1", table "userdata", field "username" I need to copy the above mentioned data to: "Database2", Table "chat_data", field "nick" I have no clue how to do it! Can anybody tell me the string? Thanks for help! Tom - 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
Copy database question
Hi everybody, I am new on mysql. I use phpadmin for adminstration. My problem: I have "Database 1", table "userdata", field "username" I need to copy the above mentioned data to: "Database2", Table "chat_data", field "nick" I have no clue how to do it! Can anybody tell me the string? Thanks for help! Tom - 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
