{"id":1308,"date":"2013-06-27T16:58:01","date_gmt":"2013-06-27T16:58:01","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1308"},"modified":"2013-06-27T16:58:01","modified_gmt":"2013-06-27T16:58:01","slug":"mysql-tip-timestamp-%ec%97%ac%eb%9f%ac%ea%b0%9c%ec%9d%bc%eb%95%8c-%ec%9e%90%eb%8f%99%ec%9e%85%eb%a0%a5","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1308","title":{"rendered":"MySql Tip &#8211; timestamp \uc5ec\ub7ec\uac1c\uc77c\ub54c \uc790\ub3d9\uc785\ub825"},"content":{"rendered":"<div>\ud574\ub2f9 Row\uc758 \uc0dd\uc131\uc2dc\uac04\uacfc \uc5c5\ub370\uc774\ud2b8 \uc2dc\uac04\uc744 \uc800\uc7a5\ud558\uace0 \uc2f6\uc740\uac00\uc694? timestamp\uac00 \ub450\uac1c \uc77c\ud150\ub370\uc694.<\/div>\n<div><\/div>\n<div>\uc774\ub54c \uc0dd\uc131\uc2dc\uac04\uc740 \uac15\uc81c\ub85c null\uc744 \ub123\uc5b4\uc900\ub2e4\uba74 default\ub85c \ud604\uc7ac \uc2a4\ud0ec\ud504\uac00 \ub4e4\uc5b4\uac00 \uac8c \ub429\ub2c8\ub2e4.<\/div>\n<div><\/div>\n<div>\uc798\uc774\uc6a9\ud558\uba74 \ud3b8\ub9ac\ud558\uaca0\uc8e0?<\/div>\n<div><\/div>\n<div><\/div>\n<div>\uc989, \u00a0timestamp \uce7c\ub7fc\uc5d0 default\ub85c &#8220;0000-00-00 00:00:00&#8243;\uc744 \uc8fc\uba74 null\uc774 \ub4e4\uc5b4\uc62c \ub54c \uc790\ub3d9\uc73c\ub85c \ud604\uc7ac\uc2dc\uac04\uc774 \uc785\ub825\ub429\ub2c8\ub2e4.<\/div>\n<div><\/div>\n<div><\/div>\n<div>\uc544\ub798 \uc608\uc5d0\uc11c c_time\uc740 \uc0dd\uc131\uc2dc\uc5d0\ub9cc null\uac12\uc744 \uc8fc\uba74\ub418\uaca0\uc8e0?<\/div>\n<div>m_time\uc740 \uc5c5\ub370\uc774\ud2b8\uc2dc \ub9c8\ub2e4 \uc790\ub3d9\uc73c\ub85c \uac31\uc2e0 \ub420\uac81\ub2c8\ub2e4^^<\/div>\n<div>\n<p>`c_time` timestamp NOT NULL DEFAULT &#8216;0000-00-00 00:00:00&#8217;,<br \/>\n`m_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,<\/p>\n<p>&nbsp;<\/p>\n<p>ALTER TABLE `\ud14c\uc774\ube14\uba85` CHANGE `\uceec\ub7fc\uba85` `\uceec\ub7fc\uba85` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\ud574\ub2f9 Row\uc758 \uc0dd\uc131\uc2dc\uac04\uacfc \uc5c5\ub370\uc774\ud2b8 \uc2dc\uac04\uc744 \uc800\uc7a5\ud558\uace0 \uc2f6\uc740\uac00\uc694? timestamp\uac00 \ub450\uac1c \uc77c\ud150\ub370\uc694. \uc774\ub54c \uc0dd\uc131\uc2dc\uac04\uc740 \uac15\uc81c\ub85c null\uc744 \ub123\uc5b4\uc900\ub2e4\uba74 default\ub85c \ud604\uc7ac \uc2a4\ud0ec\ud504\uac00 \ub4e4\uc5b4\uac00 \uac8c \ub429\ub2c8\ub2e4. \uc798\uc774\uc6a9\ud558\uba74 \ud3b8\ub9ac\ud558\uaca0\uc8e0? \uc989, \u00a0timestamp \uce7c\ub7fc\uc5d0 default\ub85c &#8220;0000-00-00 00:00:00&#8243;\uc744 \uc8fc\uba74&hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1308"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1308"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1308\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}