地區(qū)

id | name

---+---------

1 | NY

2 | Paris

3 | London

飯店

id | name | region_id

---+-----------+----------

1 | kFC |1

2 | McDonalds |2

banner_ads

id | image | fee | region_id

---+-------+------+-----------

1 |1.jpg |500 | 1

2 |2.jpg |500 | 1

3 |3.jpg |500 | 2

4 |4.jpg |500 | 3

Cuisine_promotions

id | cuisine_id | fee | region_id

---+------------+------+-----------

1 |1 |500 | 1

2 |2 |500 | 1

3 |3 |500 | 2

4 |4 |500 | 3

Sponsored_promotions

id | item_id | fee | restaurant_id

---+---------+------+--------------

1 |1 |500 | 1

2 |2 |500 | 1

3 |3 |500 | 2

4 |4 |500 | 2

我想將數(shù)據(jù)填充到此表中

region | banner_revenue | cuisine revenue | promotions_revenue | total

-------+----------------+-----------------+--------------------+--------

NY | 1000 | 1000 | 1000 | 3000

Paris | 500 | 500 | 1000 | 2000

London | 500 | 500 | null | 1000

我可以做這樣的事情

SELECT sum(fee) FROM test2.banner_ads;

SELECT sum(fee) FROM test2.cuisine_promotions;

SELECT

regions.name,

SUM(sponsored_promotions.fee)

FROM

test2.sponsored_promotions

INNER JOIN

restaurants ON sponsored_promotions.restaurant_id = restaurants.id

INNER JOIN

regions ON restaurants.region_id = regions.id

GROUP BY

regions.name;

并將以上三個(gè)值相加得出總和.

但是我正在尋找更優(yōu)雅的方式來(lái)做到這一點(diǎn).

是否可以在單個(gè)查詢(xún)中執(zhí)行此操作？沒(méi)有3個(gè)單獨(dú)的查詢(xún)？

與50位技術(shù)專(zhuān)家面對(duì)面20年技術(shù)見(jiàn)證，附贈(zèng)技術(shù)全景圖

總結(jié)

以上是生活随笔為你收集整理的mysql读取求和_MySQL从单独的表中获取求和值的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。