All Questions
400 questions
1
vote
1
answer
70
views
Filtering mysql data using nested json_table returns "Incorrect arguments"
I'm new to mysql and I'm trying to filter some data. I needed more entires to be in one column, so I used the json format.
With the help of chatgpt I'm able to search for fine, but there's a problem ...
- 13
0
votes
1
answer
43
views
How to retrieve specific field from nested json field in mysql? [duplicate]
I have following column(descrition field) in my table of data in which I have to extract country name field value. Like Spain from this field.
[
{
"key": "country_code",
...
-1
votes
1
answer
49
views
how to use inside mysql with laravel if for each product supported languages with some nested supported info ... see to understand
am using laravel with (mysql)... what i want to do is same like this:
for each product->>>
langs
english:
interface: true,
subtitles: false,
...
0
votes
0
answers
70
views
nested exception could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement"
I get a problem in postman about hibernate. can you help me?
I don`t know what is the problem, as you can see here are my codes. I got this error in IntelliJ idea ERROR: column "username" is ...
- 11
0
votes
2
answers
49
views
In a MYSQL table of word definitions, within sql add 3 columns/fields of definitions taken randomly from other rows
I have a MYSQL table called aa_ngl_defs of the following form:
id
Word
POS
Definition
1
the
article
used to point to something already mentioned
2
be
verb
used to show the identity of a thing
3
and
...
-1
votes
2
answers
71
views
Using nested queries with COUNT function
I am using an SQL table to keep track of the number of meals given to students every day. The table is structured as follows:
ID_Student
MealDate
MealType
1
2023-05-21
1
2
2023-05-21
1
1
2023-05-21
2
...
5
votes
2
answers
277
views
Output The Contents Of A Pivot / Linking Table In A Nested While Loop - MySQL / PHP PDO
I have a situation where I'm trying to output the contents of a MySQL pivot/linking table from a many-to-many relationship with PHP.
In the code below I have a series of boards that will contain ...
- 174
-2
votes
1
answer
50
views
mysql nested query - Top Three Salaries
Please help me with this issue. There are 2 tables: Employee and Department tables.
correct:
select d1.name Department, e1.name Employee, e1.salary Salary
from Employee e1, Department d1
where e1....
- 1
0
votes
1
answer
141
views
MySQL trigger's INSERT causing Cardinality violation due to 'SELECT *' in VALUES (...)
I'm having an issue with not being able to insert new records on a MySQL table that has a trigger, due to how the trigger is written. I get the error:
Cardinality violation: 1241 Operand should ...
- 33
0
votes
2
answers
1k
views
Multiple nested array from MySQL query in PHP
I'm using foreach loops to access records in a nested array.
I need to nest 3 arrays (so the first array contains an array, which also contains an array). I'm having success with 2 arrays but I can't ...
0
votes
0
answers
406
views
mysql multi layered self referencing nested join
I have 2 tables. tb_device and tb_site_object.
tb_device is quite simple:
| id | station_id |
|----|------------|
| 1 | 6 |
| 2 | 6 |
| 3 | 9 |
tb_site_object looks like ...
1
vote
2
answers
437
views
MySQL - joining a table to itself / sub queries
I'm asking for help on an assessment question I recently got wrong, I've tried a number of solutions and think I kind of know what I'm trying to do, but can't seem to figure out the syntax.
I have a ...
- 29
2
votes
1
answer
2k
views
How do I organize Nested JSON Objects Data in a SQL Database?
I have a JSON file with some data, like this:
{
"meta":{
"server":"awesome.com",
"user":"awesomeUser",
"response"...
- 21
0
votes
1
answer
89
views
Nested IF using query in PHP MySQL
I am having trouble on this code. It does not go to the 3rd condition base on query.
I have 5 columns to work with.
AMIN AMOUT PMIN PMOUT STATUS
First entry creates record is there no record for ...
- 103
1
vote
1
answer
53
views
MySQL Nested Select Querys using data from main query
I have edited the question to make the problem more simple and added the suggested changes in the coments, Thx a lot
I have a table matches with data and I need:
1- To get all the columns for matches ...
