[MySQL] error 1093 多表删除错误

mysql> select * from t;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
|  4 |
|  5 |
|  6 |
|  7 |
|  8 |
+----+
8 rows in set (0.04 sec)

01. 下面删除语句报错

mysql> delete from t where t.id in (select t.id from t where t.id > 5);
1093 - You can't specify target table 't' for update in FROM clause

02. 修改删除SQL即可

mysql> delete t from t join t b on b.id = t.id where b.id > 4;
Query OK, 4 rows affected (0.00 sec)

附: 多表删除语句

-- 删除 t1 表数据
DELETE t1 FROM t1 JOIN t2 ON t2.ref = t1.id WHERE t1.id = 1;
-- 删除 t1, t2 表数据
DELETE t1, t2 FROM t1 JOIN t2 ON t2.ref = t1.id WHERE t1.id = 1;

注意: 要删除的表在删除语句中 不可以起别名

附: 建表语句及新增数据SQL

CREATE TABLE `t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO `demo`.`t`(`id`) VALUES (1);
INSERT INTO `demo`.`t`(`id`) VALUES (2);
INSERT INTO `demo`.`t`(`id`) VALUES (3);
INSERT INTO `demo`.`t`(`id`) VALUES (4);
INSERT INTO `demo`.`t`(`id`) VALUES (5);
INSERT INTO `demo`.`t`(`id`) VALUES (6);
INSERT INTO `demo`.`t`(`id`) VALUES (7);
INSERT INTO `demo`.`t`(`id`) VALUES (8);