Auto Add of date in table

[mebil]

Hello everyone. I have a what should be a simple question.

 

Building a simple \"Known Issues\" for the office. I want to add current date in a tables shown below. Would this be a php job, forms, or can mysql do it? Also how to do it would be great.

 

CREATE TABLE issue_name (

 idissue_name INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

 name Varchar(45) NULL,

 date DATETIME NULL,

 added_by Varchar(45) NULL,

 PRIMARY KEY(idissue_name)

);



CREATE TABLE description (

 iddescription INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,

 issue_name_idissue_name INTEGER UNSIGNED NOT NULL,

 description Varchar(255) NULL,

 update_time DATETIME NULL,

 PRIMARY KEY(iddescription, issue_name_idissue_name),

 INDEX description_FKIndex1(issue_name_idissue_name),

 FOREIGN KEY(issue_name_idissue_name)

   REFERENCES issue_name(idissue_name)

     ON DELETE NO ACTION

     ON UPDATE NO ACTION

);

[effigy]

use this:

 

stamp timestamp(14) NOT NULL

 

it will stamp the record with the day and time when it is inserted and anytime it is changed.

[mebil]

Thanks!