On Mon, 5 Jan 2004, Matthew Stuart wrote:
> I am trying to create a couple of columns (one createddate and one
> updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
> but I am having trouble understanding how it works. I want both columns
> to auto add a date and time when a recor
w(),article='$text'
where id=$id";
just adjust your app's syntax as needed. But this should get your result.
Larry
-Original Message-
From: Matthew Stuart [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 7:49 AM
To: MySQL email support
Subject: struggling ne
Matthew Stuart <[EMAIL PROTECTED]> wrote on 05/01/2004 12:49:03:
> I am trying to create a couple of columns (one createddate and one
> updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
> but I am having trouble understanding how it works. I want both columns
> to auto a
Your easiest route would be to make createddate a DATETIME field and update it
yourself when you insert a record. You can then make updateddate a TIMESTAMP and let
MySQL set it to NOW() automatically for you by not specifying it in any of your insert
or update queries. If you made them both tim
I have been sent a url for datetime explanations in the MySQL manual. I
have learnt a few things, but I am also more confused than ever.
I am trying to create a couple of columns (one createddate and one
updateddate) in a MySQL table that are DATETIME or TIMESTAMP values,
but I am having troubl
