Re: What is happening with mySQL?

[Er Abbott]

Now look at this - as I've said, my personal favourite:

mysql> update usuarios set usri_id = NULL;
Query OK, 1 row affected, 1 warning (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 1

mysql> select * from usuarios;
+---------+--------+
| usri_id | login |
+---------+--------+
| 0 | galvao |
+---------+--------+
1 row in set (0.00 sec)

Wow, a warning. I don't see the reason why I've got the warning and worst of all, besides the warning everything ran fine.

Hmmmmm... Looks like I know the difference between NULL and '', huh?