This is the question in my hw Retrieve cartId having the maximum number of food items. Sample Data: (carts have multiple instances because the unitsInCart could be different items ie. 3 apples and 4 bananas) cart_items table cartId unitsInCart cart…
I have a list of elements [a, b, c, d]. I also have a table called ticket that looks like this: order_pnr_id bigint unsigned default '0' not null, order_id bigint unsigned default '0' not null, reference_ticket_id bigint unsigned default '0'…
Any idea how to convert query below into Codeigniter? select agency from agency where agency not in (SELECT agency FROM trip where trip_type = 'local trip' group by trip_type, agency having count(agency)=(select count(*) from role)); Tried but failed. Please help
MySQL container always restarting. I use docker desktop in Windows 10 Logs 2024-05-14 02:31:01+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.30-1.el8 started. 2024-05-14 02:31:02+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2024-05-14 02:31:02+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL…
I'm trying to get a comma separated list of values from one table into a new table as separate rows. Without losing key-value relations. Table 1 (original data) key values key1 val1,val2,val3,val4 key2 val1,val2,val3,val4 Table 2 (new data) key value…
we have a database table where we store a new record every 30 minutes. The data looks like this: I wrote the following query: SELECT * FROM datastore_usage WHERE datastore_id = 1 GROUP BY HOUR(created_at) ORDER BY created_at DESC LIMIT…
I'm using MySQL database. I have to join two tables (A, B). They have relationship (N->N). Actually, A is chatting room table and B is chat (chat record). Chatting room has many chats. If a user enters chat app, the…
I wrote this query to show me the last purchase of each customers using "EXISTS" but it is not working. it returns all of the rows without filtering them. Can you please advise me how to resolve this issue? Thank…
What is the architectural name or pattern for my Vue.js + Express.js + MySQL application? I need to explain the architecture of my app for a project, but I'm not sure what name or pattern to attribute to it. Vue.js…
I have tables with following structure TablePC no name party19 party24 1 A 1 1 2 B 1 2 party19 and party24 columns are Foreign key constraint to TableParty.no TableParty no name 1 X 2 Y My query select TablePC.name…