Hi,
If you read the manual, you would see that that is exactly what timestamp is
for.
Regards
Quentin
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 February 2001 14:32
To: [EMAIL PROTECTED]
Subject: Severe problem in handling timestamp column type
>Description:
There is a _severe_ problem when dealing with "timestamp" column: if I
update
a column, also other columns are affected! I enclose a sample script to
show the problem
>How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20","1999-03-04");
select * from a;
update a set t2="1998-05-06";
select * from a;
drop table a;
-- The second "select" shows that column t1 changed too!
>Fix:
I don't know. I used datetime type instead of timestamp and it _seems_
working.
>Submitter-Id: <submitter ID>
>Originator: Alex Dusty
>Organization: JapoTek
>MySQL support: none
>Synopsis: Error in handling timestamp columns
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on
i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 15 hours 23 min 8 sec
Threads: 2 Questions: 8036 Slow queries: 0 Opens: 927 Flush tables: 1
Open tables: 12 Queries per second avg: 0.145
>Environment: (tested also in other environments, always versione 3.23.32)
System: Linux japot.dyndns.org 2.2.19pre7 #8 Tue Jan 30 16:33:29 GMT+1 2001
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium'
CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer
-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Nov 23 01:05 /lib/libc.so.6 ->
libc-2.2.so
-rwxr-xr-x 1 root root 4761074 Dec 15 12:39 /lib/libc-2.2.so
-rw-r--r-- 1 root root 22855536 Dec 15 12:37 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dec 15 12:37 /usr/lib/libc.so
Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man
--without-berkeley-db '--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
