There are 2 models Buyer and BuyerOrder with 1 to many relationship. class Buyer < ApplicationRecord has_many buyer_orders end class BuyerOrder < ApplicationRecord belongs_to buyer end I need to fetch total buyer_orders count and buyer name with group by buyer_id.…
I am using Laravel 5.7 and i need to generate top selling products of current month for my reports. So i join two table products and sells. I want three columns in return which are sell_quantity, product_name*, and product_id. So…
Using Laravel 9, Im able to UPDATE an empty field hole_data by posting an array of objects: JS: data = { id:1, name:'A Name', hole_data: [{…}, {…}] } await axiosClient.post('/updateholedata', data); Laravel/PHP public function updateHoleData(Request $request) { DB::table('holes') ->where('id', $request->id)…
i want to make a application whith golang that can exec sql or command through websocket,i use package "github.com/gorilla/websocket","os/exec","os", i have finished redis-cli and mongoshell. but when i use mysql client to connect with mysql, i can't recieve message from…
I have a following table : prod_name - quantity - group tv - 30 - base microwave - 10 - base watch - 5 - base phone - 25 - base washer - 15 - base dryer. - 14 -…
I have this data in db: id | user_id | status 1 | 7 | sent 2 | 7 | pending 3 | 8 | pending 4 | 8 | sent how do I make a query so that I…
I am implementing data partitioning on mysql server(8.0). As a "must-have requirement of partitioning" I have to add my partition key as a primary key, which is created_at in my table. eg: alter table notifications drop primary key, add primary…
First, I am new to database management, so my terminology might be slightly incorrect. I have data I believe would best fit into a many-to-many bidirectional database (I am using SQL with Java). I am trying to represent the relationship…
I'm scratching my head on this one. The below essentially times out on both my local machine and AWS. Here's the kicker, each subquery runs fine. The first subquery takes 55ms and returns 24000 records. The second takes 42ms and…
I have a table mytable with name, department, rating example: a, d1, 3 b, d1, 5 c, d1, 10 a1, d2, 4 a2, d2, 1 a3, d2, 5 I want the output to group the output by department and pick…