How to make mysql copy data from one field into another using phpmyadmin

[perry789]

Hi, would anyone know if it is possible to make mysql copy the data from one field in a table into another field, using phpmyadmin to do it?

 

Thanks

[fenway]

First, why?

Second, you can use a multi-table update statement in v4.1+.

[perry789]

I have a script that i want to show the same results from 2 different fields, its hard to explain. What is a multi-table update statement and how do i use it? Thanks

[aschk]

UPDATE <tablename> SET field2 = field1;

 

backup your data first, as I won't be held responsible if this fails

[fenway]

I have a script that i want to show the same results from 2 different fields, its hard to explain. What is a multi-table update statement and how do i use it? Thanks

You can easily convert a SELECT statement into an update statement.