title: MySQL: Split column into two
body: <p>I have a table with rows like this:</p>
  
  <pre><code>| Country.Number | Country |
  | US.01          | USA     |
  | US.02          | USA     |
  </code></pre>
  
  <p>I'd like to modify this to:</p>
  
  <pre><code>| Country | Number | Country |
  | US      | 01     | USA     |
  | US      | 02     | USA     |
  </code></pre>
  
  <p>Is there an easy way to do this?</p>