title: update a whole column with the values of another column of another table mysql
body: <p>I've a table named table1 like this:  </p>
  
  <p>column1 column2 .. columnX Name     otherColumns    </p>
  
  <blockquote>
  <pre><code>                      John  
                        Paul  
                        Paul  
                        Jimmy  
                        Fred  
                        Mary
  </code></pre>
  </blockquote>
  
  <p>I know ONLY the Name column in table1.<br>
  So in my application I read the whole Name column and encrypt each value.<br>
  Now I have to update the names of table1 with their encrypted values.<br>
  What can I do? (sorry for bad format of table..)</p>