ä»å¤©å»ºäºä¸ä¸ªè¡¨ï¼éé¢æä¸ä¸ªåæ¯timestampç±»åï¼ææ¬ææ¯å¨æ°æ®æ´æ°æ¶ï¼è¿ä¸ªå段çæ¶é´è½èªå¨æ´æ°ãå²ç¥å¯¹è¿ä¸ªç±»åçå¼è¿ä¸çäºè§£ï¼å¯¼è´åºéãåç°è¿ä¸ªå段åªæ¯å¨è¿è¡æ°æ®å»ºç«çæ¶åæå¼ï¼å¨æ´æ°çå´æ ååã
   æ¥æ¾èµæï¼åç°æ¯æ建表çè¯å¥æé®é¢ï¼
   以ä¸æ¯ä»£ç ç段ï¼
CREATE TABLE `test` (
`t1` timestamp NOT NULL default CURRENT_TIMESTAMP,
`ww` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  èå®é ä¸ï¼ä»¥ä¸ä¸¤ä¸ªå»ºè¡¨è¯å¥çæææ¯ä¸æ ·ç:
CREATE TABLE `test` (
`t1` TIMESTAMP NOT NULL ,
`ww` VARCHAR( 5 ) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `test`
(
`t1` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`ww` varchar(5) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ããæ¯è¾ä¹ä¸ï¼æçè¯å¥å°äºâon update CURRENT_TIMESTAMPâæå¤äºâdefault CURRENT_TIMESTAMPâãå¦æ¤ä¸æ¥ï¼è¿ä¸ªtimestampå段åªæ¯å¨æ°æ®insertçæ¶é´å»ºç«æ¶é´ï¼èupdateæ¶å°±ä¸ä¼æååäºã
   å¨CREATE TABLEè¯å¥ä¸ï¼timestampåå¯ä»¥ç¨ä¸é¢çä»»ä½ä¸ç§æ¹å¼å£°æï¼
- å¦æå®ä¹æ¶DEFAULT CURRENT_TIMESTAMPåON UPDATE CURRENT_TIMESTAMPåå¥é½æï¼åå¼ä¸ºé»è®¤ä½¿ç¨å½åçæ¶é´æ³ï¼å¹¶ä¸èªå¨æ´æ°;
- å¦æä¸ä½¿ç¨DEFAULTæON UPDATEåå¥ï¼é£ä¹å®çåäºDEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
- å¦æåªæDEFAULT CURRENT_TIMESTAMPåå¥ï¼è没æON UPDATEåå¥ï¼åå¼é»è®¤ä¸ºå½åæ¶é´æ³ä½ä¸èªå¨æ´æ°;
- å¦æ没ç¨DEFAULTåå¥ï¼ä½æON UPDATE CURRENT_TIMESTAMPåå¥ï¼åé»è®¤ä¸º0并èªå¨æ´æ°;
- å¦ææä¸ä¸ªå¸¸éå¼DEFAULTï¼è¯¥åä¼æä¸ä¸ªé»è®¤å¼ï¼èä¸ä¸ä¼èªå¨åå§å为å½åæ¶é´æ³ãå¦æ该åè¿æä¸ä¸ªON UPDATE CURRENT_TIMESTAMPåå¥ï¼è¿ä¸ªæ¶é´æ³ä¼èªå¨æ´æ°ï¼å¦å该åæä¸ä¸ªé»è®¤ç常éä½ä¸ä¼èªå¨æ´æ°
   æ¢å¥è¯è¯´ï¼ä½ å¯ä»¥ä½¿ç¨å½åçæ¶é´æ³å»åå§åå¼åèªå¨æ´æ°ï¼æè æ¯å ¶ä¸ä¹ä¸ï¼ä¹å¯ä»¥é½ä¸æ¯ãï¼æ¯å¦ï¼ä½ å¨å®ä¹çæ¶åå¯ä»¥æå®èªå¨æ´æ°ï¼ä½å¹¶ä¸åå§åãï¼ä¸é¢çå段å®ä¹è¯´æäºè¿äºæ åµï¼
èªå¨åå§ååæ´æ°:
`ts` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
åªèªå¨åå§å:
`ts` timestamp DEFAULT CURRENT_TIMESTAMP
åªèªå¨æ´æ°
`ts` TIMESTAMP DEFAULT 0 ON UPDATE CURRENT_TIMESTAMP
åªæ¯ç»ä¸ä¸ªå¸¸éï¼æ³¨ï¼0000-00-00 00:00:00ï¼
`ts` timestampDEFAULT 0
注æï¼å¦æä¸ä½¿ç¨DEFAULTæON UPDATEåå¥ï¼é£ä¹å®çåäºDEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  示ä¾ï¼
CREATE TABLE `test` (
`ww` VARCHAR( 9 ) NOT NULL ,
`t1` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`t2` TIMESTAMP NOT NULL
) ENGINE = MYISAM
ãè¿ä¸ªæ åµä¸ï¼æ°æ®æå ¥æ¶ï¼t1ä¼è®°å½å½åæ¶é´ï¼t2为é»è®¤å¼ï¼0000-00-00 00:00:00ï¼ï¼çåä¸é¢çè¯å¥ï¼
CREATE TABLE `test` (
`ww` VARCHAR( 9 ) NOT NULL ,
`t1` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`t2` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE = MYISAM
ãæ ¹æ®ä¸é¢æ³¨æäºé¡¹ï¼ç¤ºä¾çå表è¯å¥å®æ´çè¯å¥åºå½ä¸ºï¼
CREATE TABLE `test` (
`ww` VARCHAR( 9 ) NOT NULL ,
`t1` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`t2` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE = MYISAM
ã  æ¾ç»æ³è¿æ ·è®¾è®¡ä¸ä¸ªè¡¨ï¼è¿ä¸ªè¡¨æ两个timestampåï¼ä¸ä¸ªå¯ä»¥è®°å½æ´æ°æ¶é´ï¼ä¸ä¸ªå¯ä»¥è®°å½åå§æ¶é´ï¼ä½æ¯å°è¯å¤æ¬¡ä»¥åï¼æåç°mysql好ååä¸å°è¿ä¸ç¹ï¼ä¸ç¥éè¿ä¸ªæ¯mysqlç缺é·è¿æ¯èªæä¼åï¼å 为ï¼è¿ä¸ªåè½å¯ä»¥ä½¿ç¨datetimeå®ç°è®°å½åå§åçæ¶é´ï¼åªæ¯éè¦insertçæ¶åæå®ä¸ä¸.