Hello,
The manual says that TIMESTAMP should work. What does this mean? When I
replicate a table with such a field, the values on the slave is
different. Is this OK or a bug?
I'm trying to use this field to avoid data overwrite. In a JSP page I
select a record, read TIMESTAMP field value, and when applying the
changes I use a statement like :
"update table set... where ID=? and TS=?"
where ID is key field and TS is TIMESTAMP field. In the case that
someone else modified the record, I can get a error (update count should
be 1).
When replicating, the TS values are diferent so the above statement
isn't working because of TS condition.
Can anyone help?
(mysql version 3.23.33)
Thanks,
Gabriel Corneanu
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
