UPDATE _field1 = _feild2 for every row <p>Is there a way to update a Table, and move the data from one row to another? For example, could I use the following syntax?</p> <pre><code>UPDATE _tablename SET _field1 = _field2; </code></pre> <p>Normally <code>UPDATE</code> queries require a <code>WHERE</code> parameter don't they?</p>