MYSQL临时表,大数据查询优化

最新推荐文章于 2024-11-29 11:22:51 发布

奔跑的蜗牛$

最新推荐文章于 2024-11-29 11:22:51 发布

阅读量2k

点赞数

文章标签： php mysql

本文链接：https://blog.youkuaiyun.com/qq_59037327/article/details/123901192

版权

/*创建临时表 */
CREATE TEMPORARY TABLE tmp_table (
   order_num INT ( 10 ) NOT NULL,
   order_sum DECIMAL ( 10, 2 ) NOT NULL,
   finish_parking_region_id INT ( 10 ) NOT NULL
)
/*删除临时表*/
DROP TABLE rich_table_sum

/*创建与写入临时表数据*/
CREATE TEMPORARY TABLE tmp_table(
   SELECT
       count( order_id ) AS order_num,
       sum( pay_amount - refund_amount ) AS order_sum,
       finish_parking_region_id
   FROM
       rich_orders
   WHERE
       settlement_time BETWEEN 1648137600
       AND 1648828799
       AND order_state = 2
       AND finish_parking_region_id <> 0
   GROUP BY
       finish_parking_region_id
   )

/*查询临时表*/
SELECT * FROM tmp_table