set @@session.tidb_batch_delete = 1;
set @SESSION.tidb_dml_batch_size = 1;
DELETE a FROM ods_order_item_base_two a INNER JOIN order_data_difference_temp b ON a.item_no = b.item_no AND b.pay_flag = ‘1’;
麻烦执行下下面 SQL : commit ; set @@session.tidb_batch_delete = 1; set @SESSION.tidb_dml_batch_size = 1; DELETE a FROM ods_order_item_base_two a INNER JOIN order_data_difference_temp b ON a.item_no = b.item_no AND b.pay_flag = ‘1’;
如果还是有报错的话,麻烦再一次提供 TiDB 完整的报错信息 。