<div>
<div class="content wysiwyg-content">
I had several people doing data entry and one person put data in the wrong field. A field that should be empty for now.<br />
<br />
Is there an SQL statement that I could use to transfer all data from one field to another within the same row for all rows in a table. <br />
<br />
Basically I want to do something like this:<br />
<br />
Field1 = Field1 + ' ' + Field2<br />
Field2 = ''<br />
Repeat for every row in table.<br />

</div>
</div>


I had several people doing data entry and one person put data in the wrong field. A field that should be empty for now.

Is there an SQL statement that I could use to transfer all data from one field to another within the same row for all rows in a table. 

Basically I want to do something like this:

Field1 = Field1 + ' ' + Field2
Field2 = ''
Repeat for every row in table.


MySQL move data to another field

I had several people doing data entry and one person put data in the wrong field. A field that should be empty for now.

Is there an SQL statement that I could use to transfer all data from one field to another within the same row for all rows in a table. 

Basically I want to do something like this:

Field1 = Field1 + &#39; &#39; + Field2
Field2 = &#39;&#39;
Repeat for every row in table.


MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.