--- 建表
create table SCORE_fengzi
(
cname VARCHAR(10),
sciense VARCHAR(10),
score INT
)
--- 插入数据
insert into SCORES values("zhangsan","language",81);
insert into SCORES values("zhangsan","math",75);
insert into SCORES values("lisi","language",76);
insert into SCORES values("lisi","math",90);
insert into SCORES values("wangwu","language",81);
insert into SCORES values("wangwu","math",100);
insert into SCORES values("zhaoliu","language",61);
insert into SCORES values("zhaoliu","math",78);
insert into SCORES values("liuqi","language",100);
insert into SCORES values("liuqi","math",89);
---变更表名称
数据库与MPP数仓(十九):高效SQL
最新推荐文章于 2024-08-20 07:00:00 发布
本文深入探讨了如何在MPP(大规模并行处理)数据仓库中编写高效的SQL查询,以提升数据库性能。通过实例分析,展示了针对MySQL和RDB数据库优化SQL语句的方法,包括使用合适的数据类型、索引策略以及查询优化技巧。
摘要由CSDN通过智能技术生成