Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
mysql> \r test
Connection id:    6
Current database: test

mysql> create table henkdetank (id int primary key auto_increment, a date, b tim
e, c datetime);
Query OK, 0 rows affected (0.17 sec)

mysql> insert into henkdetank (a,b) VALUES (NOW(), NOW());
Query OK, 1 row affected (0.08 sec)

mysql> SELECT * FROM henkdetank;
+----+------------+----------+------+
| id | a          | b        | c    |
+----+------------+----------+------+
|  1 | 2007-09-24 | 15:36:50 | NULL |
+----+------------+----------+------+
1 row in set (0.00 sec)

mysql> UPDATE henkdetank SET c = CONCAT(a,' ',b);
Query OK, 1 row affected (0.08 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM henkdetank;
+----+------------+----------+---------------------+
| id | a          | b        | c                   |
+----+------------+----------+---------------------+
|  1 | 2007-09-24 | 15:36:50 | 2007-09-24 15:36:50 |
+----+------------+----------+---------------------+
1 row in set (0.00 sec)

mysql>