Hello DRH The question is this: Should the no-op UPDATE statement (x=x) cause DRH the ON UPDATE SET NULL foreign key constraint to set t2.y to NULL or DRH not?
I think MySQL knows if a row gets actually updated. If the values in a row don't change, then it says that no rows were updated. I was surprised at first, but I suppose it is quite handy to know if anything was really changed. To get round this, I found a suggestion that you have a dummy column in the table, and you make it default to 0 and then on each update, set it to 1 - dummy. Swithun. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
