Category "mysql"

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

I want to merge similar data I get with foreach

There are product categories that I bought through the API service and these categories come as text. Since the categories are similar, I want to group them and

pod mysql mount azure files failed

wanna deploy a mysql in cluster, and pod need a persistent storage, here are yaml & pictures: The pod: apiVersion: v1 kind: Pod metadata: name: mypod spec

Retrieval of highest value of a column and their dates

I have done code in MySQL to get the highest deaths value country-wise with their reporting date in MySQL. I am being able to get the highest deaths value but t

MYSQL or Laravel Eloquent How To Count The Detail From This Order

[MYSQL QUERY / LARAVEL ELOQUENT QUESTION] Hi, I really need some help with MYSQL Query this 3 tables I have. The order table and the details it's a manually inp

Loopback 4 - Is it possible to define id property's length?

Using LB4 + MySQL DB through loopback-connector-mysql to create tables on DB. A {id: string, name: string} id names 0007bc40-814b-11ec-8128-4df48bd1ae4d John 0

mysql return 360 degrees returned with strengths

I have a table of wind directions and strengths over a 24 hour period, sample data at the bottom of this question. only directions that have strengths are store

NodeJS MySQL DB connection fail

thank you in advance for the help. I am using nodejs v16.13.1 and mysql 5.7.37-cll-lve. my nodejs app is currently on my local machine and my mysql db is on a r

SQL inner join performance data duplicate

table -- > qt qstnId tagId 1 1 1 2 2 3 2 4 2 2 table --> question qid 1 2 qid is primary key and qstnId is Fk now when i'm running query --> mysql&

COUNT the result from external table in Mysql always return 0 value

I tried to count rows with from 2 different table. the scenario is If status on tbl_task waiting, this job will not yet got the sales_id from tbl_sales. Once th

Thymeleaf + spring save new object instead of update

I am asking for a hint. I searched the internet for a long time for a solution to the problem, but I'm already desperate. I would like the update operation to u

Mac terminal bash profile cannot add another path after downloading Anacoda

I started to learn MySQL recently and I have a 2015 MacBook Air. After installing MySQL server, I ran pip install MySQL-connector-python. Everything worked perf

How to get max value from a MySQL Database

I have an MYSQL database table of student info and their test scores per subject and I am trying to fetch each student's highest score in all subjects using the

How to Connect to MySQL datbase using Swift-Nio

I used node js to connect mysql server and it is working good. I used the API developed in node js and used in the local macOS app. The problem is querying the

How to Laravel Mysql fetch data from database using multiple table join

This is my data retrieving query: $admin_students=DB::select("select students.*,application_record.*,gender_record.*, application_record.id as app_primary_id,ap

I want to build a login form that allows users to access the welcome page using only their passwords

I want to build a login form : users access the welcome page using their passwords.

Laravel weird issue: query return data with DB::table() but not with model::

I found an issue when delete some data, so I isolated the code Route::get('v1/testapi', function (Request $request) { return [ DB::table('attendances')->

Laravel weird issue: query return data with DB::table() but not with model::

I found an issue when delete some data, so I isolated the code Route::get('v1/testapi', function (Request $request) { return [ DB::table('attendances')->