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
I m looking for advices in report generating per client, per product, per salesman, in a given period, using mysql and php. I m currently working on an applicat
I have the following query to get appointments that need remind once a month if they are not done yet. I want to get records with 30, 60, 90, 120,etc... in the
This must be a niche scenario since I have not been able to find a similar question around and in my brief testing in my SQL workbench just using the string in
I have python script which uses subprocess.run() getting dump file by curl and input dump file by mysql cmd = "curl {0}/{1} -o /tmp/{2}".format(dir_name,file_na
in Mysql I am trying to get end date excluding weekends like my function GET_DATE_WEEKDAYS('2022-03-24',5) giving - 2022-03-17 which is fine it is giving issue
I created a table with a query: CREATE TABLE Department ( EmpID INT NOT NULL, Designation VARCHAR(80) NOT NULL, Department VARCHAR(80) NOT NULL, PRIMARY KEY(Emp
I am attempting to connect a FastAPI with sqlAlchemy to a mysql db container. I am using the alias. Unfortunately it wont connect and I don't know why. Using My
When running this site locally, no problem. I have my server/client in different folders and the server is set to update the database on Heroku. I have one simp
first i have two problem here the first problem when i run this query it gives me this Error //ERROR SQLSTATE[42S22]: Column not found: 1054 Unknown column '390
Trying to link two tables that are in one database please help with syntax