mysqlã®timestampåã¯ä»ã®ä¸»ãªRDBMSã¨éã£ã¦åæã«å¤ãæ ¼ç´ãããããã ãã¨ãDEFAULTå¤ã«now()ã®ãããªé¢æ°ã使ããã¨ãåºæ¥ãªãã£ã½ãã ãã®ä»£ããã«ã¨ãã£ã¦ã¯ã¢ã¬ã ãã©ON UPDATE CURRENT_TIMESTAMPã®ãããªå±æ§ã使ããã®ã§ãæ´æ°æ¥æã®ãããªå¤ãä¿æããã«ã¯ãã£ã¦ããã®åã¿ããã ã§ãä»åããããã£ãã®ã¯ã²ã¨ã¤ã®ãã¼ãã«ã« modified_date 㨠create_date ã®ãããª2ã¤ã®timestampåã®ã«ã©ã ãä½ã£ã¦ãæ´æ°æ¥æã¨ãã¼ã¿ãæåã«ä½ã£ãæ¥ã®ä¸¡æ¹ã管çããæ¹æ³ã ã¹ãã¼ãã¯ãããªæãã§å®ç¾©ãã¦ãã CREATE TABLE `test` ( id int(4) unsigned NOT NULL auto_increment, name varchar(10) , . . ç¥ . . modified_date tim
{{#tags}}- {{label}}
{{/tags}}