goInception icon indicating copy to clipboard operation
goInception copied to clipboard

delete语句使用别名导致审核报错

Open dbadylan opened this issue 2 years ago • 2 comments

delete语句如果使用了别名,审核会报错: 1

如果去掉别名,则审核正常: 2

goInception版本: 3

dbadylan avatar Sep 15 '22 07:09 dbadylan

MySQL能执行通过吗? 可以试试

DELETE t FROM t1 as t WHERE t.id=1;

hanchuanchuan avatar Sep 17 '22 03:09 hanchuanchuan

@hanchuanchuan mysql是可以正常执行的: 1

dbadylan avatar Sep 18 '22 06:09 dbadylan

关键在于DELETE后面是否跟了表别名t. 注意检查语法.

hanchuanchuan avatar Oct 18 '22 13:10 hanchuanchuan