pátek 18. prosince 2009

Databázový vtip - MySQL

select * from tabulka where datum is null;
...
18 rows

update tabulka set datum='1970-01-01' where datum is null;
Query OK, 0 rows affected

WTF?

update tabulka set datum="1970-01-01" where datum='0000-00-00';
Query OK, 18 rows affected

MySQL!

1 komentář: