Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

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