DROP TABLE EVENTS;
CREATE TABLE EVENTS(MAC bigint NOT NULL, Node tinyint, Datim DateTime NOT NULL,
Type tinyint NOT NULL, Event smallint NOT NULL, Status tinyint NOT NULL);
Insert into events(MAC, Node, Datim, Type, Event, Status) values(0x123456789abc, 4, '2014-05-13 13:25:30:001', 1, 27, 1);
Insert into events(MAC, Node, Datim, Type, Event, Status) values(0x123456789abc, 4, '2014-05-13 13:25:30:002', 1, 27, 1);
select * from events;
Results:
20015998343868 4 2014-05-13 13:25:30.000 1 27 1
20015998343868 4 2014-05-13 13:25:30.003 1 27 1
Why?
