title: Update an entire row in MySQL
body: <p>I'm new to MySQL and I want to update an entire row in MySQL with a new array, so far all the examples of the Update query involves specifying the column name and a new value for that column, like this:</p>
  
  <pre><code>"UPDATE tablename SET columnname = '".$new_value."' WHERE columnname = '".$value."'";
  </code></pre>
  
  <p>How can I update an entire record with the update query or should I use the replace query?</p>
  
  <p>Any advice will be appreciated.</p>
  
  <p>Edit: Is there a query which doesn't require to specify all the column names and new column values?</p>
  
  <p>Basically I want to have a query that looks something like this:</p>
  
  <p><em>Update entirerow with thisarray where primarykeycolumn='thisvalue'</em></p>