perry789 Posted February 28, 2008 Share Posted February 28, 2008 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted February 28, 2008 Share Posted February 28, 2008 First, why? Second, you can use a multi-table update statement in v4.1+. Quote Link to comment Share on other sites More sharing options...
perry789 Posted February 28, 2008 Author Share Posted February 28, 2008 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 Quote Link to comment Share on other sites More sharing options...
aschk Posted February 29, 2008 Share Posted February 29, 2008 UPDATE <tablename> SET field2 = field1; backup your data first, as I won't be held responsible if this fails Quote Link to comment Share on other sites More sharing options...
fenway Posted February 29, 2008 Share Posted February 29, 2008 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.