cupen · August 29, 2015 14:06
diff --git a/just_biang_biang.sql b/just_biang_biang.sql
 CREATE TABLE `test` (
 `i`  int(255) NULL DEFAULT 0 
 )
 ENGINE=InnoDB
 DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci


 SELECT
    t1.i as idx1,
    t2.i as idx2

 FROM
    test as t1 
    LEFT JOIN test as t2 ON (t1.i - t2.i) = 1

 WHERE
    ISNULL(t2.i);
	CREATE TABLE `test` (
	`i` int(255) NULL DEFAULT 0
	)
	ENGINE=InnoDB
	DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci


	SELECT
	t1.i as idx1,
	t2.i as idx2

	FROM
	test as t1
	LEFT JOIN test as t2 ON (t1.i - t2.i) = 1

	WHERE
	ISNULL(t2.i);