Category "mysql"

Java Spring JPA Query Error: '(',<expression>,FUNCTION or identifier expected, got '('

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

Some table rows are not returned by hibernate native query

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

Sequelize: find count of 3 level associated model entries

I have a products database structure as follows: Categories > Sub categories > Child categories > Products the respective table names in mySql database

How can I find out, check and change my $db_host, user, pass, name in mysql workbench?

$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

displaying data of table from database using python

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

I am not being able to connect to my MariaDB remotely

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

Connection of Android Studio project to MySQL database

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

It keeps displaying the last data

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

MySQL 8.0, Ubuntu 20: Permission Error after Changing Datadir after Reinstall

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

How to connect to MySQL server using Entity Framework Core

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

REGEXP word match

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

A null was returned after calling the 'GetService' method on a store provider instance of type 'MySql.Data.MySqlClient.MySqlClientFactory'

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

Cannot access my Local mysql server from Minikube Cluster

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

Control the order of adjacent columns when selecting SUM

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

Random "Error Establishing a Database Connection" occuring once every 1 - 2 weeks

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".

Exception ignored in: <function BaseMySQLSocket.__del__ at 0x000002B15E76E5E0>

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

How can I update values in MySQL database table to conform to a different pattern?

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

When I try to open MAMP in windows it throws error "install .Net core"

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

How to search JSON array in MySQL using sqlalchemy?

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

When searching for non-primary key in MySQL using DAO it keeps returning a null object

The first method works but the second method keeps returning a null object. I don't see any difference except that flight_no is the primary key. What went wrong