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
