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
I'm running a service called Keycloak in Minikube for Development purposes and want to connect MySQL Database which is running on my Local Computer. I can able
When you select by a SUM, the returned data is grouped to a single record, which is fine. The query below correctly returns the sum, but the adjacent column val
I am running WordPress 5.9.3 on Ubuntu 20.04 using Apache and once every 1 - 2 weeks my website goes into a state of "Error Establishing a Database Connection".
I have this strange error in my code, it started to show just like that - no changes in the code. The same code is working with no problems when I run it from p
I intend to clean some data in a MySQL database table for some data that was not properly captured. The table in question contains numerous columns but the colu
After installing MAMP in windows, when I open it, it throws the below error. "To run this application, you must install .Net core. Would you like to download it
I have one JSON column in my table. I want to filter by this column using sqlalchemy with Python and MySQL. I've tried in this way, but unsuccessfully. My colum