mysqlテンポラリ・テーブルの作成

作成:

	create table tmp_(SELECT
				*
			FROM
				shzy.social_qd_db_all_dxy a 
			WHERE
				1 = 1 
			and pz_date >= DATE_FORMAT('2019-03-25 10:01:01','%Y-%m-%d %H:%i:%s') 
			and pz_date <= DATE_FORMAT('2019-03-25 10:15:00','%Y-%m-%d %H:%i:%s') 
			);

クエリー:

	select a.* from tmp_ a ,tmp_ b where a.cph!=b.cph 
			and 0 < TIMESTAMPDIFF(MINUTE, a.pz_date, b.pz_date)<10
			and 0 < TIMESTAMPDIFF(MINUTE, a.mz_date, b.mz_date)<10
			and 0 < a.mz - b.mz <500;

削除:

drop table shzy.tmp_;