title: insert a MYSQL 5.7 point representation of latitude,longitude into a table
body: <p>I have a table geom as follows:</p>
  
  <pre><code>id (Int) not null (pk),
  name (varchar 25),
  timestamp (timestamp),
  lat (decimal 6,4),
  lon (decimal 6,4),
  g (geometry),
  pt (point)
  </code></pre>
  
  <p>I have another process that populates the lat,lon fields.</p>
  
  <p>I want to populate the pt field to take advantage of 5.7's geospatial extensions</p>
  
  <p>if I fat finger the lon,lat into the following insert statement is works fine:</p>
  
  <pre><code>set@g='point( -80.00 40.00)';
  
  insert into geom (pt,timestamp) values (pointfromtext(@g),now());
  </code></pre>
  
  <p>but I would like to use the values stored in that record's lon,lat fields</p>
  
  <p>I can create  what looks like the right value using a concat statement but the insert  "pointfromtext" statement will not take the result</p>