mebil Posted November 11, 2003 Share Posted November 11, 2003 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 ); Quote Link to comment https://forums.phpfreaks.com/topic/1343-auto-add-of-date-in-table/ Share on other sites More sharing options...
effigy Posted November 11, 2003 Share Posted November 11, 2003 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. Quote Link to comment https://forums.phpfreaks.com/topic/1343-auto-add-of-date-in-table/#findComment-4444 Share on other sites More sharing options...
mebil Posted November 11, 2003 Author Share Posted November 11, 2003 Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/1343-auto-add-of-date-in-table/#findComment-4447 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.