Hi all, I was wondering if it is possible to have the default value of an integer field be the current UNIX timestamp ?
MySQL doesn't allow me to use .... not null default UNIX_TIMESTAMP() ..... If anyone knows a way of achieving this, it would be great =) Also, I currently use "int(10) unsigned not null default 0" for my unix timestamp fields, is there perhaps a more efficient field type I should be using? Thx -- Keith Bussey Mana Internet Solutions, Inc. Chief Technology Manager +50 6 280 2284 ext.108 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]