How to replicate a timestamp field

Hello. I know that when a timestamp field has default current_timestamp on update current_timestamp, it will be updated for each update. Question: I have a slave server which replicate this field (The master is deployed Europe and the slave in Brazil). The time of fly to replicate the query

Int(4) or int(8)

hi all The mysql manual inform that: EX. century int(4) The result is that values in the century column usually are displayed four digits wide. However, its important to undesrstand that the display width is unrelated to the range of the datatype. The display width specified for a column

Decimal versus Float Point Type

Dear all. The MySQL Manual inform that Decimal Data Type is used for represent exact-number, but like Float Point Data Type, Decimal use rounding case the fractional part is not sufficient. Therefore, what the difference? Regards Bruno R. Silva

#1205 - Lock wait timeout exceeded; Try restarting transaction

I am using tables INNODB. After one query, the MySQL does not liberate the LOCK, and when I try to execute same query it appears the message. #1205 - Lock wait timeout exceeded; Try restarting transaction whait urgently one helps. thanks, Bruno -- MySQL General Mailing List For list

Why mysql LOCK any lines and does not allow that I delete?

I am with a problem in one query of simple DELETE. #1205 - Lock wait timeout exceeded; Try restarting transaction Why mysql LOCK this line and does not allow that I delete, if I did not emit none stantment of LOCK? Please, help me! Bruno Rodrigues Silva Brazil. -- MySQL General Mailing List