Bug or Feature in MySQL v5.0
am 01.02.2010 23:47:37 von 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--
Re: Bug or Feature in MySQL v5.0
am 02.02.2010 04:41:22 von 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 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