--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--

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 [at] 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
>



--
Eric Bergen
eric.bergen [at] 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 [at] m.gmane.org

--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--