title: MySQL--unknown column in field list
body: <p>I don't see why the UPDATE below works fine in the console but fails in my Java code</p>
  
  <pre><code>MariaDB [testdb]&gt; DESCRIBE datasift_geo;
  +-------------+---------------------+------+-----+---------+-------+
  | Field       | Type                | Null | Key | Default | Extra |
  +-------------+---------------------+------+-----+---------+-------+
  | datasift_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
  | latitude    | decimal(17,14)      | YES  |     | NULL    |       |
  | longitude   | decimal(17,14)      | YES  |     | NULL    |       |
  | location    | varchar(100)        | YES  |     | NULL    |       |
  | coord       | point               | YES  |     | NULL    |       |
  +-------------+---------------------+------+-----+---------+-------+
  5 rows in set (0.00 sec)
  
  MariaDB [testdb]&gt; SELECT * FROM datasift_geo;
  +-------------+-------------------+-------------------+------------+-------+
  | datasift_id | latitude          | longitude         | location   | coord |
  +-------------+-------------------+-------------------+------------+-------+
  |        1601 | 51.45713800000000 | -2.60802800000000 | Bristol UK | NULL  |
  +-------------+-------------------+-------------------+------------+-------+
  
  MariaDB [testdb]&gt; UPDATE datasift_geo SET coord = GeomFromText('POINT(51.45713800000000 -2.60802800000000)');
  Query OK, 1 row affected (0.01 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  </code></pre>
  
  <p>================</p>
  
  <pre><code>@Test
  public void testGeoCoord() throws SQLException {
      int id = 1601;
      float latitude = 51.45713806152344f;
      float longitude = -2.608027935028076f;
      String sql = "UPDATE `datasift_geo` SET `datasift_geo`.`coord` = GeomFromText('POINT(" + latitude + " " + longitude + ")') WHERE datasift_id = " + id;
      // get database connection, create a PreparedStatement, execute the UPDATE
  }
  </code></pre>
  
  <p>======</p>
  
  <p>Result of executing the UPDATE</p>
  
  <blockquote>
    <p>java.sql.SQLSyntaxErrorException: Unknown column 'datasift_geo.coord'
    in 'field list'</p>
  </blockquote>