我有一个MySQL的表格和其中的数据条目:
CREATE TABLE `invoices`.`invoices` (
`InvoiceID` bigint(20) unsigned NOT NULL auto_increment,
`UserID` int(10) unsigned NOT NULL,
`Value` decimal(10,3) NOT NULL,
`Description` varchar(4048) NOT NULL,
`DateTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`InvoiceID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin5;
我想要移除 "on update CURRENT_TIMESTAMP" 的条件。我该如何修改这个表格?
CURRENT_TIMESTAMP
,但在更新时保持不变。 - aularonts
ts
TIMESTAMP NOT NULL DEFAULT 0; CREATE TABLEtmpx
(ts
timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',id
int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id
) ) ; insert into tmpx values(null, null); - almaruf