运行MySQL 5.6.7-rc,据称支持fractional seconds in time values.正当
在MySQL Workbench 5.2.44中试试这个:
CREATE TABLE T (dt DATETIME);
INSERT INTO T (dt) VALUES ('2012-11-12 13:54:00.123');
SELECT dt FROM T;
输出如下:
2012-11-12 13:54:00
What am I missing here?