Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'picture_***.d.buy_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]
SQL
SELECT d.oder_id, d.buy_date,SUM(d.sum) as sum ,SUM(d.price) as price FROM (phpbb_m_pt_buy_photo_detail d) GROUP BY d.oder_id
Expression #2 of SELECT SUM()
Moderator: mindphp
- thatsawan
- PHP VIP Members
- Posts: 28523
- Joined: 31/03/2014 10:02 am
- Contact:
-
- Similar Topics
- Replies
- Views
- Last post
-
- 1 Replies
- 44477 Views
-
Last post by mindphp
02/05/2017 11:48 pm
-
- 0 Replies
- 486 Views
-
Last post by M027
20/08/2015 10:02 am
-
- 0 Replies
- 753 Views
-
Last post by thatsawan
21/03/2015 6:35 pm
-
-
ทำความรู้จักกับภาษา python (47) : Regular Expression (รีกูวล่า)
by dawthana » 23/01/2017 2:47 pm » in Python Knowledge - 1 Replies
- 507 Views
-
Last post by dawthana
23/01/2017 2:53 pm
-
-
-
อยากทราบว่า regular expression urllib คืออะไร ทำงานยังไงครับ
by บัวบุญ จันทะโคตร » 11/08/2017 3:17 pm » in Programming - C/C++ & java & Python - 1 Replies
- 305 Views
-
Last post by P'Eak
16/08/2017 9:08 pm
-
-
- 1 Replies
- 389 Views
-
Last post by mindphp
19/07/2017 3:42 am
Who is online
Users browsing this forum: No registered users and 4 guests