如何在2小时之间从mysql中检索计数

Consider the following table:

请考虑下表:

CREATE TABLE `trans` (
  `transid` varchar(255) NOT NULL,
  `affid` varchar(255) NOT NULL,
  `timestamp` varchar(255) NOT NULL,
  UNIQUE KEY `transid` (`transid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE