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]

Reply via email to