On Mon, 19 Apr 2004 17:36:50 -0500, Paul DuBois wrote:
Sorry if I wasn't clear. One of the things you wanted to do was have a column that is set automatically to record-creation time when the record is created, but not updated automatically when the record is updated later. You will be able to do this in 4.1.2 with TIMESTAMP, which is what the example below demonstrates.
This applies only to TIMESTAMP. You will not otherwise be able to specify functions as default values.
Ok thanks. Hmm. Will timestamp's value range be increased so that it can store the same range of dates as datetime?
Not that I know of.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
