delete from test as t where t.id='101' and t.idd in(5,6);语法错误,这是什么问题
delete from test where id='101' and idd in(5,6);
delete from test t where t.id='101' and t.idd in(5,6) 不要那个as试试