UPDATE tA SET createdate = NOW(), begdate = FORM_DAYS(TO_DAYS(NOW()) + TO_DAYS(begdate) - TO_DAYS(createdate)) WHERE ID = 1
? 不太明白呀. SHOW CREATE TABLE .. 把表结构的 创建语句帖出来看看.
这样应该就可以了,注意update的顺序不能换: UPDATE tablename SET begdate= from_days(to_days(from_unixtime(unix_timestamp(now())+unix_timestamp(begdate)-unix_timestamp(createdate)))),createdate = NOW() WHERE id = 1;
SET createdate = NOW(),
begdate = FORM_DAYS(TO_DAYS(NOW()) + TO_DAYS(begdate) - TO_DAYS(createdate))
WHERE ID = 1
不太明白呀.
SHOW CREATE TABLE ..
把表结构的 创建语句帖出来看看.
UPDATE tablename SET begdate= from_days(to_days(from_unixtime(unix_timestamp(now())+unix_timestamp(begdate)-unix_timestamp(createdate)))),createdate = NOW() WHERE id = 1;