mysql´¢´æÊ±¼äÑ¡ÔñÔõÑùµÄ×Ö¶ÎÀàÐÍ
´¢´æÊ±¼ä£¬³£ÓõÄÓÐÈý¸öÑ¡Ôñdatetime
¡¢timestamp
¡¢int
¡£×òҹͬÊÂÎʵ½ÁË£¬ÓÚÊǽñÌì¾Í×ܽáÒ»ÏÂ×Ô¼ºµÄÀí½â¡£
- ²åÈëЧÂÊ£ºdatetime > timestamp > int
- ¶ÁȡЧÂÊ£ºint > timestamp > datetime
- ´¢´æ¿Õ¼ä£ºdatetime > timestamp = int
½¨Á¢Ë÷ÒýµÄÌå»ý£¬ºÍË÷ÒýµÄËÙ¶È£¬Äã¶®µÄ¡£
ÈÃÎÒÃÇÀ´¿´Ò»¸öÓ¦Óó¡¾°£º
¿´ÏÂÕâÕÅͼ£¬µÚÒ»ÎÒÃÇÐèÒªÉèÖÃϵͳµÄĬÈÏÊ±Çø£¬µÚ¶þÎÒÃÇÒ²ÐèÒªÌṩ²»Í¬Ê±ÇøÊ±¼äÏÔʾµÄÐèÒª¡£ÓÚÊÇ£¬ÎÒÃÇ·Ö±ðʹÓÃdatetime
¡¢timestamp
¡¢int
×Ö¶ÎÀàÐÍÀ´¿´Ï£º
ʹÓÃdatetime
Ö±½ÓÏÔʾʱ¼ä£¬ÕâÊǸö²»´íµÄÑ¡Ôñ£¬µ«ÊÇÈç¹û¿¼Âǵ½Ê±Çø£¬ºÜÃ÷ÏÔ¼ÆËãÉϵÄÂé·³¡£
ʹÓÃtimestamp
OK,Õâ¸öºÜºÃ£¬¿ÉÒÔ¸ù¾ÝϵͳµÄÊ±ÇøÀ´×Ô¶¯Êä³öʱ¼ä£¬µ«Êǵ¥¸öÓû§Òª¶¨ÖÆ×Ô¼ºµÄÊ±ÇøÄØ£¿ÔÙÕßÄã²»ÅÂÂé·³£¬ÔÚ³ÌÐòÀïÃæÊµÏÖÁËÕâ¸ö¼ÆË㣬·þÎñÆ÷ÈôÊÇ»»¸öµØ·½£¬¸ÄÁËÏÂÊ±Çø£¬Äã³ÌÐòÀïÃæ¼ÆËãµ¥¸öÓû§µ±µØÊ±¼äµÄ´úÂëÔõô°ì£¨timestamp³öÀ´µÄʱ¼ä»á¸ù¾ÝÊ±ÇøµÄ±ä»¯¶ø±ä»¯£¬ÔÚijЩÇé¿öÏÂÊDz»´íµÄÑ¡Ôñ£¬µ«ÔÚijЩÇé¿öÏ£¬ÕæµÄºÜ¼¦Àߣ©¡£
ʹÓÃint
´ÓÉÏÃæÁ½¸öÀàÐ͵Äȱµã¿´À´£¬Ã²ËÆÕâ¸öÀàÐÍ¿ÉÒÔ½â¾öÒÔÉϵÄÎÊÌ⣬ÆäʵÎÒÃÇÖ»Òª´æ¸ñÁÖʱ¼äµÄunix timestamp¾ÍºÃÁË£¬Ê±ÇøÊ±¼äµÄ¼ÆËãÉÏÒ²ºÜ·½±ã£¬¶ÁÈ¡µÄЧÂÊÒ²²»´í¡£ÎÒ¾õµÃÓÃÕâ¸ö´¢´æµÄȱµãÄØ£¬¾ÍÊÇÖ±½ÓselectµÄʱºòʱ¼ä²»ÄÜÖ±¹ÛµÄÏÔʾ³öÀ´¡£
¿´¿´ÆäËû¿ªÔ´³ÌÐòÊÇÔõô×öµÄ
discuz, typecho, emlogµÈµÈµÈµÈ£¬ËûÃǶ¼Ñ¡ÓÃintÁË£¬ÕâÒ»¶¨ÓÐËûÃǵĵÀÀí£¬ÎÒÏëҲûʲô¿ÉÒÔ¶à˵µÄÁË¡£
ÍÆ¼öÐÅÏ¢
ÈÈÃÅÐÅÏ¢
- nohup: redirecting stderr to stdou....
- ʹÓÃlog_formatΪNginx·þÎñÆ÷ÉèÖøüÏêϸµÄÈÕÖ¾¸ñʽ
- jquery easyUI--dataGrid-Json
- [Ô´´]·ÂGoogle Reader¡¢ÐÂÀË΢²©¡¢ÌÚѶ΢²©µ....
- ÀûÓÃKeepalived+mysql¹¹½¨¸ß¿ÉÓÃMySQLË«Ö÷×Ô¶....
- Nginx+keepalivedʵÏÖ¸ºÔؾùºâºÍË«»úÈȱ¸¸ß¿ÉÓÃ
- jqueryʵÏÖÒ³Ãæ¼ÓÔØ½ø¶ÈÌõ
- Rolling cURL: PHP²¢·¢×î¼Ñʵ¼ù
- codeigniter ·ÓÉÖÕ¼«ÓÅ»¯(url rewrite)
- linuxÏÂÉèÖÃsshÎÞÃÜÂëµÇ¼
ÆÀÂÛ