Consulta mysql

[huesos52]

Código MySQL:

mysql> DESC coordenadas;
+----------+------+------+-----+---------+-------+
| Field    | Type | Null | Key | Default | Extra |
+----------+------+------+-----+---------+-------+
| latitud  | text | YES  |     | NULL    |       |
| longitud | text | YES  |     | NULL    |       |
| lat_lon  | text | YES  |     | NULL    |       |
+----------+------+------+-----+---------+-------+
3 rows in set (0.03 sec)
 
mysql> INSERT INTO coordenadas (latitud,longitud) VALUES('65','73');
Query OK, 1 row affected (0.00 sec)
 
mysql> SELECT *FROM coordenadas;
+---------+----------+---------+
| latitud | longitud | lat_lon |
+---------+----------+---------+
| 65      | 73       | NULL    |
+---------+----------+---------+
1 row in set (0.02 sec)
 
mysql> UPDATE coordenadas SET lat_lon=CONCAT(latitud,' ',longitud);
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0
 
mysql> SELECT *FROM coordenadas;
+---------+----------+---------+
| latitud | longitud | lat_lon |
+---------+----------+---------+
| 65      | 73       | 65 73   |
+---------+----------+---------+
1 row in set (0.00 sec)
 

así?