title: How to copy text column value from one row to another row in mySQL
body: <p>I have table pref having column value. This value has type text. I want copy the value field value of row with id 7 to the value field of row with id 1. Can you please help how to do this. I know MS SQL, but I am new to mySQL.</p>
  
  <pre><code>create table pref
  (
     id int,
     value text
  )
  </code></pre>