TIMESTAMP does what you want, but if you for any reason wish to update records
(mass updates) at the mysql> prompt without updating the TIMESTAMP, you'd be out
of luck. For databases where I know that mass updates to data files will be
required, and I want to preserve the user's LAST_MODIFIED (TI
You can use TIMESTAMP field for this. It's automatically assigned current date if you
don't insert anything in this field type or insert null.
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 7:56 AM
To: MYSQL
Subject: Insert de
Arthur,
Tuesday, October 15, 2002, 2:56:13 PM, you wrote:
A> In access Now() as table field default sets the field when a new
A> record is created. In SQL Server there is getdate() & suser_sname()
You can't use the return value of a function as a default value.
A> Is there an equivalent f
In Mysql (http://www.mysql.com/doc/en/Date_and_time_functions.html)
funnily enough:
NOW() orSYSDATE()
will return what you want.
Regards
M
-Original Message-
From: Arthur [mailto:[EMAIL PROTECTED]]
Sent: 15 October 2002 12:56
To: MYSQL
Subject: Insert default Date
Hello MYSQL,
In access Now() as table field default sets the field when a new
record is created. In SQL Server there is getdate() & suser_sname()
Is there an equivalent for MySQL?
--
Best regards,
Arthur mailto:[EMAIL PROTECTED]
---
