INTERSECT需要模拟为
MySQL:
SELECt 'robot' AS `set`, r.*FROM robot rWHERe ROW(r.col1, r.col2, …) NOT IN ( SELECt col1, col2, ... FROM tbd_robot )UNIOn ALLSELECt 'tbd_robot' AS `set`, t.*FROM tbd_robot tWHERe ROW(t.col1, t.col2, …) NOT IN ( SELECt col1, col2, ... FROM robot )



