Re: unwanted timestamp update

2002-11-22 Thread Stefano Locati
Hello everyone, try using: update szurtcounter set hely='kulfold', datum=datum; instead of: update szurtcounter set hely='kulfold'; this works, maybe there are better ways. Regards, Stefano Locati - http://dev.obliquid.com/ > now i run an SQL query like this one: > > update szurtcounter set

Re: unwanted timestamp update

2002-11-22 Thread Jocelyn Fournier
Hi, Take a look here : http://www.mysql.com/doc/en/DATETIME.html "Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: a.. The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. b.. The column is not specified explicitly i

Re: unwanted timestamp update

2002-11-22 Thread Paul DuBois
At 20:16 +0100 11/22/02, ozy wrote: Hello everyone, /first of all, sorry about my bad english :-)/ i had just found some interesting thing with MySQL 3.23 (win2000). i have a table like this: ++---+--+-+-+---+ | Field | Type | Null | Key