Help on a mysql table

[brearley147]

This is for mysql but i thought u guys would know, please can u tell me what is the problem here for this table.

 

CREATE TABLE bank (

  id int(11) NOT NULL auto_increment,

  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

  sendby varchar(20) NOT NULL default '',

  sendto varchar(20) NOT NULL default '',

  amount varchar(20) NOT NULL default '',

  PRIMARY KEY  (id)

) ENGINE=MyISAM AUTO_INCREMENT=3067 DEFAULT CHARSET=latin1;

 

 

 

Thanks, Ash

[revraz]

My guess would be

 

`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

 

I never seen a create command with a on update setting.