Hi,
I have just checked the logs, and the point is that in the update log
there are statements for setting the timestamp, and in the binary log
not.
Is this OK?
Thanks again.
Gabriel
> -----Original Message-----
> From: Gabriel Corneanu
> Sent: Monday, April 30, 2001 11:23 AM
> To: MySQL Mailing list (E-mail)
> Subject: TIMESTAMP Replication!!
>
> 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
