I have a common aggregation query: SELECT products.type, count(products.id) FROM products INNER JOIN product_colors
How to select record in the database using BETWEEN in sql? what I want here is to select record within the startDate and endDate. if the record is exists within
I have a problem in my website, I have 2 dropdown selects that are Departments and Locations, my problem is when I select a certain department and start typing
Here is my query: INSERT INTO film_new (SELECT title, rental_rate,length,film_id,length,release_year FROM film) JOIN film_actor ON film.film_id = film_actor
I am creating an API with express.js for a food app and I can't figure out what is the best (most efficient) way to query the data and send it
I have a DB MYSQL with many schema. Around 5k - 7k schemas. My system sometime meet OOM Killer case. Is that unnormal ? we have 5 scheme different structure. Th
I have a DB MYSQL with many schema. Around 5k - 7k schemas. My system sometime meet OOM Killer case. Is that unnormal ? we have 5 scheme different structure. Th
I am working on a project where a thread is run and opens a permanent database connection. The reason for this, is potentially as the project grows it could rec
I have two tables txn_maxvoucherno (companycode, dbcode, vouchertype, fyear, series, voucherno) txn_vouchersdetails (voucherno, vouchertype) I am executing a st
SQLSTATE[HY000]: General error: 6 Error on delete of '/tmp/#sql_10f07_0.MAI' (Errcode: 2 "No such file or directory") this error has started to pop up every no
I tried to connect to my MySQL-Database from my Home-PC and got the error: 'Can't connect...' Inside this Server with Skript and Konsole I've got no problems, b
I have a table with 2 columns: Id | Date 1 | 2022-04-01 With tons of row, like 30k I need modify all the dates, so I want to upload a CSV wi
I have a front end code of react is import React,{useEffect,useState} from "react"; import axios from 'axios' export default function DataGridDemo() { con
The following is the simplest possible example, though any solution should be able to scale to however many n top results are needed: Given a table like that b
I'm trying to run my php-based application, which connects to a mysql DB, launched through docker-compose. i get this message when i connect to localhost: Fatal
I want to build a MySQL query for a Woo database schema to get simple/variable products, but in a specific order: I want to get them in an ID ASCending order, b
I am trying to produce a data from a football table. The table can be seen below and the data that is needed is highlighted. The data that needs to be produced
I'm trying to improve my query for this topic at hand. I'm trying to find the top 5 and bottom 5 growth rates per state from 2020 to 2021 in my org. The table h
I have been exploring dbt tools and I came across the following code snippet : coalesce(customer_orders.number_of_orders, 0) as number_of_orders I understand th
I got a list of IDs as comma seperated list of JSON values and some example data sets are like below [340596,340597,340595] This list can be huge sometimes 50k