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? -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Stormblade (Shaolin Code Warrior) Software Developer (15+ Years Programming exp.) My System: http://www.anandtech.com/mysystemrig.html?rigid=1683 -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
