mysql\u3067timestamp\u578b\u3092\u4f7f\u3063\u3066\u66f4\u65b0\u65e5\u6642\u3068\u4f5c\u6210\u65e5\u6642\u306e\u4e21\u65b9\u3092\u8a18\u9332\u3057\u305f\u3044
\n———————————————-
\ncreated timestamp NOT NULL default ‘0000-00-00 00:00:00’,
\nmodified timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
\n———————————————- <\/p>\n
\nmysql> INSERT INTO test ( name , create_date ) VALUES ( ‘foo’ , NULL );
\nQuery OK, 1 row affected (0.00 sec)<\/p>\n
mysql> select * from test;
\n+—-+——+———————+———————+
\n| id | name | create_date | modified_date |
\n+—-+——+———————+———————+
\n| 1 | foo | 2010-01-26 15:27:59 | 2010-01-26 15:27:59 |
\n+—-+——+———————+———————+
\n1 row in set (0.00 sec)<\/p>\n
———————————————<\/p>\n
\n———-\u30c6\u30b9\u30c8\u7528\u306e\u30c6\u30fc\u30d6\u30eb—————–
\nCREATE TABLE `test` (
\n id int(4) unsigned NOT NULL auto_increment,
\n name varchar(10) ,
\n create_date timestamp NOT NULL default ‘0000-00-00 00:00:00’,
\n modified_date timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
\n PRIMARY KEY (id)
\n);<\/p>\n
\nmysql> desc test;
\n+—————+—————–+——+—–+———————+—————————–+
\n| Field | Type | Null | Key | Default | Extra |
\n+—————+—————–+——+—–+———————+—————————–+
\n| id | int(4) unsigned | NO | PRI | NULL | auto_increment |
\n| name | varchar(10) | YES | | NULL | |
\n| create_date | timestamp | NO | | 0000-00-00 00:00:00 | |
\n| modified_date | timestamp | YES | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
\n+—————+—————–+——+—–+———————+—————————–+
\n4 rows in set (0.00 sec)<\/p>\n
————————————<\/p>\n
http:\/\/www.dbonline.jp\/mysql\/table\/index6.html<\/p>\n","protected":false},"excerpt":{"rendered":"