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

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

测试维度	测试SQL
'='等于查询（根据主键）	SELECT * from test WHERE id=‘菜鸟教程’;
'='等于查询（根据根据唯一键）	SELECT * from test WHERE score=‘30’;
<>不等于查询	SELECT * from test WHERE score <> 40
>大于查询	SELECT * from test WHERE score > 40
>= AND <=大于等于且小于等于查询	SELECT * from test WHERE score>=40 and score<=90
BETWEEN 范围内查询	select * from test where sorce between 10 and 60
IN 包含查询	select * from test where score in(23,47,68)
NOT IN 不包含查询	select * from test where score not in(47,68)
IS NULL 为空查询	select name from test where name is null
LIKE 模糊查询	select name from test like ‘%lisa%’
DISTINCT 去重查询	select distinct(score) from test
COUNT 统计查询	select count(1) from test
AVG 平均值查询	select avg(score) from test
SUM 求和查询	select sum(score) from test
MAX 最大值查询	select min(score) from test
MIN 最小值查询	select min(score) from test
ORDER BY 排序查询	Text
EXISTS 子查询的查询	Text
INNER JOIN 内连接查询	Text
LEFT JOIN 外连接查询	Text
SIMPLE_RANGES 简单范围查询(主键range)	SELECT c FROM test WHERE id BETWEEN ? AND ?
SUM_RANGES 范围求和	SELECT SUM(k) FROM test WHERE id BETWEEN ? AND ?
ORDER_RANGES 简单范围查询(排序)	SELECT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c
DISTINCT_RANGES 去重范围查询(主键range + 排序 + 去重)	SELECT DISTINCT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c
INSERT INTO…VALUES(value1) 单条插入数据	INSERT INTO test VALUES(value1)
INSERT INTO…VALUES(value1，value1) 多条插入数据	INSERT INTO test VALUES(value1，value1)
INSERT INTO…SELECT… 写入数据	INSERT INTO test SELECT * from a;
UPDATE 更新数据	UPDATE name SET id=99 WHERE id=?;
DELETE 删除数据	DELETE FROM CUSTOMER WHERE id=?;