Jump to content


Photo

Auto Add of date in table


  • Please log in to reply
2 replies to this topic

#1 mebil

mebil
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 11 November 2003 - 04:49 PM

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);


#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 11 November 2003 - 05:30 PM

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.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 mebil

mebil
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 11 November 2003 - 06:02 PM

Thanks!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users