I am working on an application using NextJS and Typescript and am attempting to determine the best way to properly type my MySQL responses. Here is the API endpoint: import { hash } from "bcrypt"; import type { NextApiRequest, NextApiResponse…
I have the following tables: Table 1: Number PK Word PK 1 A 1 B 1 C 2 B 2 A 2 C 3 J 3 K 3 B Table 2: Number2 Word2 1 A 2 X 3 B I…
I have a database with email and phone columns. One email can have several phones, which results in multiple rows with same email but different phone numbers. I want to query all emails with it's phones grouped in one single…
I'm building a form that has a select component that is wrapped with an array from an API MySQL "get" call. The array contains 3 items; userID, firstName and lastName. Upon making a selection, the value of the select input…
It is complicate situation I installed [email protected] through brew zsh can't find mysql command. so, I add mysql path to ~/.zprofile but still zsh can't find mysql, in addition can't find brew if I remove mysql path, then zsh can…
I am working with a booking appointment system. I want to find out how many time slots are available and how many time slots are already booked. time slot count will be change base on the appointment. I used laravel…
How do i go on about on a query for where i wanna extract the same first name but the last name is different? NAME ------ Chris Stutter Chris Lamb Alfred Dark Kristine Light output: Chris Stutter Chris Lamb
Good morning! I'm a bit stuck with this question. I know it's not complicated (Because I'm pretty sure I'm close to the answer) But I've been Stuck for a bit now. I'm totally new to MySQL My database code :…
Example: SELECT COUNT(id) AS total_orders, ( ( SELECT COUNT(id) FROM orders WHERE status = 'Closed' ) / total_orders * 100) AS percent_closed_orders FROM orders Question: How can I use total_orders in the subquery? I get a an error "unknown column…
I'm looking to fetch the last 10 item IDs in a single value separated by commas, like: 123,456,789 etc However, MySQL just doesn't seem to work the way I think. I try: SELECT GROUP_CONCAT(item.id) AS Item_IDs FROM items GROUP BY…