Jump to content

Archived

This topic is now archived and is closed to further replies.

SteveVR

Moving data from one column to another

Recommended Posts

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. :!:

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.