Jump to content

Archived

This topic is now archived and is closed to further replies.

mebil

Auto Add of date in table

Recommended Posts

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

);



Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.