CREATE TABLE t1 (
id tinyint NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
pID tinyint NOT NULL,
hidden tinyint NOT NULL,
`count` tinyint NOT NULL,
added DATE NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO t1 VALUES
(NULL, 'nm1', 3, 0, 0, 0),
(NULL, 'nm2', 6, 0, 0, 0),
(NULL, 'nm32', 5, 0, 0, 0),
(NULL, 'nm4', 6, 0, 0, 0),
(NULL, 'nm5', 7, 0, 0, 0);
SELECT * FROM t1 t;
CREATE TABLE t2 (
id tinyint NOT NULL AUTO_INCREMENT,
`name` varchar(25) NOT NULL,
pID tinyint NOT NULL,
hidden tinyint NOT NULL,
`count` tinyint NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO t2 VALUES
(NULL, 'nm1', 3, 0, 0),
(NULL, 'nm2', 4, 0, 0),
(NULL, 'nm3', 5, 0, 0),
(NULL, 'nm4', 6, 0, 0),
(NULL, 'nm5', 7, 0, 0),
(NULL, 'nm6', 5, 0, 0),
(NULL, 'nm7', 6, 0, 0),
(NULL, 'nm8', 7, 0, 0);
SELECT * FROM t2;
SELECT t2.* FROM t2 LEFT JOIN t1
USING(id)
WHERE IFNULL((t2.pID != t1.pID OR t2.name != t1.name), 1);
|