记录一次 添加脚本的记录+改错记录

1.Update 和 Delete 一定要记得where条件

update 表名称 set 字段1=‘修改的值’ （单引号） where 字段=‘’ and Aid=‘’;

update jxkh22 set JXKH2200='001' ,JXKH2201='002' where B00='3' and JXKH2203='4';
1

delete from table_name where condition

delete from jxkh65 where JXKH2200='0' and JXKH6500='1';
1

2.sql 的group by 和 count

SELECT column1, column2, COUNT(*) AS count
FROM your_table
GROUP BY column1, column2
HAVING COUNT(*) > 1;
1
2
3
4

group by 之后再 count(*)>1

3.insert 和 delete

INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, ...);

1
2
3

DELETE FROM table_name
WHERE condition;

1
2
3

4.记录一次修改bug的思路

没数值

接口为：ExportExamineResultScore
debug 最后结果

明显没查出来

应该就是 这个mapper