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>