Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: Bug or Feature in MySQL v5.0

Posted on 2010-02-01 23:47:37 by Chuck Savage

--000e0cd719f29c2cdc047e91c5a4
Content-Type: text/plain; charset=ISO-8859-1

Before I go reporting this, I'd like to confirm this is a bug.

I have a table, with a field 'timestamp' and of type 'timestamp', without
any trigger code the timestamp changes automatically if I change any field
values. Bug or Feature?

In addition it doesn't set it automatically on an insert.
--
Chuck Savage
http://SeaRisen.com

--000e0cd719f29c2cdc047e91c5a4--

Report this message

#2: Re: Bug or Feature in MySQL v5.0

Posted on 2010-02-02 04:41:22 by Eric Bergen

The first timestamp has magic properties by default. See:
http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

On Mon, Feb 1, 2010 at 2:47 PM, Chuck Savage <chuck@searisen.com> wrote:
> Before I go reporting this, I'd like to confirm this is a bug.
>
> I have a table, with a field 'timestamp' and of type 'timestamp', without
> any trigger code the timestamp changes automatically if I change any fiel=
d
> values. =A0Bug or Feature?
>
> In addition it doesn't set it automatically on an insert.
> --
> Chuck Savage
> http://SeaRisen.com
>



--=20
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Report this message

#3: Re: Bug or Feature in MySQL v5.0

Posted on 2010-02-02 07:38:06 by Chuck Savage

--000e0cd48496367ae5047e9858d2
Content-Type: text/plain; charset=ISO-8859-1

Thanks for the replies everyone. I learn something every day.

--
Chuck Savage
http://SeaRisen.com

--000e0cd48496367ae5047e9858d2--

Report this message