MySQL a update casu

[ivop na regionet.cz]

Jan Kasprzak wrote:
> 
>         Co si o tom myslite? Nepochopil jsem neco ja nebo MySQL?
> Verze 3.22.14, uz by chtela upgradovat, ale co uz.

Verze MySQL-3.22.27-1cs (z RH6.1cz) se na tomto prikladu chova mravne:

mysql> select * from pokus;
+---------------------+
| t                   |
+---------------------+
| 2000-03-31 16:01:17 |
| 2000-03-31 16:01:23 |
| 2000-03-31 16:01:25 |
| 2000-03-31 16:01:25 |
+---------------------+
4 rows in set (0.00 sec)

mysql> update pokus set t=date_add(now(), interval 1 year );
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4  Changed: 4  Warnings: 0

mysql> select * from pokus;
+---------------------+
| t                   |
+---------------------+
| 2001-03-31 16:01:49 |
| 2001-03-31 16:01:49 |
| 2001-03-31 16:01:49 |
| 2001-03-31 16:01:49 |
+---------------------+
4 rows in set (0.00 sec)

ip
-- 
E-mail: Ivo.Panacek na regionet.cz
WWW:    http://ivop.regionet.cz
Mobile: +420 602 337776