Jump to content


Moving data from one column to another

  • Please log in to reply
2 replies to this topic

#1 SteveVR

  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 April 2003 - 12:39 PM

Please help!
I am trying to transfer data from one column (\"email_cust\") in a table to another column (\"email\") in the same table using phpMyAdmin. Renaming the columns doesn\'t do it since the data is then in the wrong place in the table.
The table is called \"links\".
I have tried the following: UPDATE `links` set email = email_cust;
but get the message \"The directory you set for upload work cannot be reached\"
Can anybody tell me what to do?
Thanks in anticipation. :!:

#2 effigy

  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 24 April 2003 - 02:21 PM

never tried this. you could possibly make a select email, email_cust from links then loop through the results to create update queries and run those?
Regexp | Unicode Article | Letter Database

#3 SteveVR

  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 24 April 2003 - 06:45 PM

Thanks for your reply.
In the end though, I worked out that I had to dump the contents of the table from within phpmyAdmin and then open a new phpmyAdmin window.

Using the command UPDATE `links` set email = email_cust
the data was read from the dump and copied from email_cust into the email field.

Yippee! don\'t have to cut and paste 1330 email addresses.

Thanks again :lol:

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users