两款数据库性能对比测试的维度

针对下面的内容，可以区分单线程和多线程的测试，同时针对每个维度的测试，建议执行3次，并取测试结果的平均值作为对比维度。

                     测试维度                                           测试SQL

1. '='等于查询（根据主键）               |     SELECT * from test WHERE id='菜鸟教程'; |
2. '='等于查询（根据根据唯一键）      | SELECT * from test WHERE score='30'; |
3. <>不等于查询                              | SELECT * from test WHERE score <> 40 |
4. >大于查询                                   | SELECT * from test WHERE score > 40 |
5.  >= AND <=大于等于且小于等于查询       | SELECT * from test WHERE score>=40 and score<=90 |
6. BETWEEN 范围内查询                   | select * from test where sorce between 10 and 60 |
7. IN 包含查询                        | select * from test where score in(23,47,68) |
8. NOT IN 不包含查询            | select * from test where score not in(47,68) |
9. IS NULL 为空查询           | select name from test where name is null |
10. LIKE 模糊查询                | select name from test like '%lisa%' |
11. DISTINCT 去重查询         | select distinct(score) from test |
12. COUNT 统计查询          | select count(1) from test |
13. AVG 平均值查询           | select avg(score) from test |
14. SUM 求和查询              | select sum(score) from test |
15. MAX 最大值查询          | select min(score) from test |
16. MIN 最小值查询        | select min(score) from test |
17. ORDER BY 排序查询         | Text |
18. EXISTS 子查询的查询         | Text |
19. INNER JOIN 内连接查询       | Text |
20. LEFT JOIN 外连接查询        | Text |
21. SIMPLE_RANGES 简单范围查询(主键range)          | SELECT c FROM test WHERE id BETWEEN ? AND ? |
22. SUM_RANGES 范围求和                | SELECT SUM(k) FROM test WHERE id BETWEEN ? AND ? |
23. ORDER_RANGES 简单范围查询(排序)            | SELECT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c |
24. DISTINCT_RANGES 去重范围查询(主键range + 排序 + 去重)        | SELECT DISTINCT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c|
25. INSERT INTO...VALUES(value1) 单条插入数据              | INSERT INTO test VALUES(value1) |
26. INSERT INTO...VALUES(value1，value1) 多条插入数据           | INSERT INTO test VALUES(value1，value1) |
27. INSERT INTO..SELECT.... 写入数据              | INSERT INTO test SELECT * from a; |
28. UPDATE 更新数据         | UPDATE name SET id=99 WHERE id=?; |
29. DELETE 删除数据      | DELETE FROM CUSTOMER WHERE id=?; |