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
I'm asking the question cuz all the related posts i found are not answered Error at line 21 Screenshot Hello guys I need some help with this Query, at line 21 I
I'm having a big problem that a few rows of the table are not returning by the native query of hibernate (Spring Data), although if I put the same query in the
I have a products database structure as follows: Categories > Sub categories > Child categories > Products the respective table names in mySql database
$db_host = ""; $db_user = ""; $db_pass = ""; $db_name = ""; I have to fill out these, so I wanted to check but I used 'ampps' to install mysql. so I couldn't f
I am newbie to python ,trying with simple programs given below is a program which i tried to get the data from table and displaying it. Installed Python3.4 and
So I have a MariaDB running on my Raspberry and I have created some Android apps that read/write data to that database. Yesterday the apps were not able to conn
I am developing an android studio project and would like to be able to access data from a database sitting on the pc which I am programming from. I would like t
I'm trying to let user to change the phone number of specific company user entered and displays the new information to user Currently, when I click the change b
hope to be in the right place to ask this. I previously used a Debian cloud instance with an added data drive to store a MySQL database. I moved the datadir the