帮忙翻译sql injection violation, dbType mysql, , druid-version 1.2.9, syntax error: syntax error, error in :'in order by tl.top_id desc ,tc.create_t', expect ), actual BY, pos 847, line 51, column 12, token BY : select count(0) from (select tld.dispatch_list_num, tl.top_id, bl.id as bom_id, bl.bom_version, tc.id, tc.task_list_details_id, tc.task_name, tc.pn_code, tc.product_type, tc.details, tc.check_type, tc.check_num, tc.stock_num, tc.check_user_id, tc.check_user_name, tc.producer_id, tc.producer_name, tc.company_id, tc.`delete`, tc.create_time, tc.update_time, tc.product_name, tc.total_num from task_check tc left join task_list_details tld on tld.id=tc.task_list_details_id left join bom_list bl on bl.id=tld.bom_id left join task_list tl on tl.id=tld.task_list_id where tc.`delete` = 0 and tld.company_id = ? and tld.top_id in order by tl.top_id desc ,tc.create_time desc) tmp_count;
时间: 2024-02-14 07:23:46 浏览: 111
SQL注入违规,数据库类型为MySQL,Druid版本为1.2.9,语法错误:语法错误,错误在于:'in order by tl.top_id desc, tc.create_t',期望为“)”,实际为“BY”,位置在第847个字符,第51行,第12列,关键字为BY。查询语句如下:
select count(0) from (select tld.dispatch_list_num, tl.top_id, bl.id as bom_id, bl.bom_version, tc.id, tc.task_list_details_id, tc.task_name, tc.pn_code, tc.product_type, tc.details, tc.check_type, tc.check_num, tc.stock_num, tc.check_user_id, tc.check_user_name, tc.producer_id, tc.producer_name, tc.company_id, tc.`delete`, tc.create_time, tc.update_time, tc.product_name, tc.total_num from task_check tc left join task_list_details tld on tld.id=tc.task_list_details_id left join bom_list bl on bl.id=tld.bom_id left join task_list tl on tl.id=tld.task_list_id where tc.`delete` = 0 and tld.company_id = ? and tld.top_id in order by tl.top_id desc, tc.create_time desc) tmp_count;
阅读全文