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
I am using Visual Studio 2019 community edition. I want to connect to MySQL using Entity Framework core. I do not want to use Entity Framework 6. I am running i
I have a script where I am attempting to match a new jobtitle to an existing one in the database. SELECT a.title AS JobTitle, j.Description AS MatchedJobTitle
I recently upgraded my database to mySQL 8.0.28, mySQL .NET Connector 8.0.28 & Entity Framework 6.4.4. Now when making a DB call from code I am receiving th