title: Convert lat/lng pairs using GeomFromText('POINT(1 1)') and insert in another column
body: <p>In my previous question <a href="https://stackoverflow.com/questions/7112661/search-for-range-latitude-longitude-coordinates">Search for range Latitude/Longitude coordinates</a>   My solution was to create the table below.</p>
  
  <pre><code>mysql&gt; select * from spatial_table where MBRContains(GeomFromText('LINESTRING(9 9, 11 11)'), my_spots);
  +------+---------------------------------+
  | id   | my_spots    | my_polygons       |
  +------+-------------+-------------------+
  |    1 |  $@      $@     $@      $@      |
  +------+-------------+-------------------+
  </code></pre>
  
  <p>Now I need to convert and move my existing lat/lng pairs in the table below to spatial_table. How would I structure my query to acheive this? I am currently using the queries below to insert.</p>
  
  <pre><code>mysql&gt; insert into spatial_table values (1, GeomFromText('POINT(1 1)'), GeomFromText('POLYGON((1 1, 2 2, 0 2, 1 1))'));
  Query OK, 1 row affected (0.00 sec)
  
  mysql&gt; insert into spatial_table values (1, GeomFromText('POINT(10 10)'), GeomFromText('POLYGON((10 10, 20 20, 0 20, 10 10))') );
  Query OK, 1 row affected (0.00 sec)
  </code></pre>
  
  <p>Existing table:</p>
  
  <pre><code>+-------------+---------+--------+-----------+----- ------+-------------+--------------+
  | location_id | country | region |  city     | latitude   | longitude   |     name     |
  +=============|=========|========|===========|============|=============|==============|
  |   316625    |   US    |   CA   | Santa Cruz|  37.044799 | -122.102096 |  Rio Theatre |
  +-------------+---------+--------+-----------+------------+-------------+--------------+    
  </code></pre>