On Tue, Jul 3, 2012 at 2:43 PM, Paul van Helden <p...@planetgis.co.za>wrote:
> >> The statement "UPDATE table SET column=NULL" updates every row in the >> table. The fact that some rows may already have a NULL in that >> column is not important. >> >> Well, it is important to me, the word "change" means before != after :-) > Just checked MySQL: UPDATE testtable SET testrow=NULL; Affected rows: 40 UPDATE testtable SET testrow=NULL; Affected rows: 0 That is what I'm familiar with. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users