bitscn.com
mysql查询记录时间相邻的相同号码,记录间隔小于指定秒数的记录 #表结构 create table `tmp_20120710_3` (  `id` int(11) not null auto_increment,  `desttermid` varchar(11) default null,  logtime varchar(20) default null,  primary key (`id`)) engine=innodb default charset=gbk#排序    
 #导入结构相同的临时表#从pk上保证相同号码记录时间相邻insert into `tmp_20120710_4` (desttermid, logtime) select desttermid, log_time from `tmp_20120710_3` order by desttermid, logtime#记录时间格式yyyymmddhhmmss#转换成以秒为单位的时间戳计算记录间隔#对desttermid字段值相同、记录时间相邻的时间戳相减 select a.desttermid, abs(unix_timestamp(a.logtime) - unix_timestamp(b.logtime)) as timediff, a.logtime, b.logtime from `tmp_20120710_4` a, `tmp_20120710_4` b where a.desttermid = b.desttermid and a.id = b.id + 1 and timediff   bitscn.com