blob: 4d90cf34cf79742ceceb0d9cd54c7ea542a26ccc (
plain)
1
2
3
4
|
ALTER TABLE /*_*/transcache MODIFY tc_time binary(14);
UPDATE /*_*/transcache SET tc_time = DATE_FORMAT(FROM_UNIXTIME(tc_time), "%Y%c%d%H%i%s");
INSERT INTO /*_*/updatelog VALUES ('convert transcache field');
|