Questions tagged [mysql]
MySQL is a free, open-source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. Those are different DBs that all use their own dialects of SQL to manage the data. Always specify the exact version of the server in the question. Note that configuration/setup-related questions are off-topic on stackoverflow.
mysql
662,114
questions
0
votes
2
answers
46
views
MergingTwo SQL Queries Select and Count in Single statement
I am Working on project, where I am using two queries to get the result i wanted to process.
Query 1
SELECT MID FROM PMS.MACHINE WHERE STATUS=1 AND MID !=0;
Query 2
SELECT MID,COUNT(STATUS) AS QUEUE
...
0
votes
1
answer
39
views
Detecting OR operator sequences and wrapping their content in a parenthesis when building a query with PHP
I made the following PHP code to build a query based on user input, where they can choose the condition and the operator and the resulting query would be printed on their screen every time they added ...
1
vote
0
answers
31
views
How to calculate Running balance in RDLC reports?
I have an application that uses C#, Entity framework core & MySql database for tracking income & expense and i'm using RDLC for reporting.
I have a transactions table for tracking income and ...
0
votes
1
answer
29
views
MySQL: How to pull in values from 2 different tables in one row?
If I also want to pull form.form_name into my results on the same row, how would I adjust my query below? The form_id in the form table = the form_id in the form_version table. I also need to filter ...
-2
votes
0
answers
24
views
MacBook remote database access works with Sequel Ace and MySQL Workbench but not php (not a duplicate) [duplicate]
My remote database access works with Sequel Ace and MySQL
Workbench but not php
My connection script contains the exact same data.
I've searched everywhere for a solution.
Any idea why?
Thanks.
Robert
...
-7
votes
0
answers
34
views
How does JSON ensure conventions of relational database management systems, as it is denormalizes data? [closed]
MYSQL being a relational DBMS has support for JSON documents using the JSON data type.
According to Codd's rules for relational database management,
Every data dimension should be equivalent in its ...
0
votes
1
answer
33
views
Eloquent ORM performance with subqueries for relational models
Laravel eloquent uses subqueries for relationship model instead of joins as joins offer more optimal performance .How does eloquent orm ensures performance for relational models ?
1
vote
1
answer
25
views
Get JSON Parent object name in MySql 8
{
"hi": {
"blue_line_branch": {
"stations": {
"1_station_name": "यमुना बैंक",
"2_station_name": "लक्समी नगर&...
0
votes
1
answer
28
views
Laravel app getting "[1045] Access denied for user 'root'@'172.19.0.4'" error when connecting to MySQL Docker container
I'm facing an issue connecting my Laravel application to a MySQL Docker container. When I run php artisan migrate, I'm getting the following error:
SQLSTATE[HY000] [1045] Access denied for user 'root'...
3
votes
0
answers
60
views
Bottom-up tree structure cumulative sum
entityid
parentid
emission
E1
E2
541
E2
E4
272
E3
E4
270
E4
NULL
362
I have the above tree structure, my goal is to calculate the cumulative sum of each node, with weighted contribution from the ...
0
votes
2
answers
52
views
Sum values between a lot of date-ranges in a single column
I'm trying to figure out how to get a sum of value by transaction dates over a 90 day period and repeated over a single year's worth of transaction dates.
This is what I have
transaction_date
value
...
0
votes
0
answers
36
views
React Form Submission Logs Updated Data but Does Not Update Database or Navigate to Tasks Page
now i 'm creating endpoint for editing task for to do app using laravel and react.js
the end point i tested it using postman and it returns success response http://localhost:8000/api/tasks/4
and the ...
0
votes
0
answers
45
views
Problem with Spring Boot,mysql and Docker
I have a spring boot application that has a connection to the mysql database, when I try to dockerize it and create the image whenever the application image will run these logs
2024-07-24 17:45:44 ...
-1
votes
1
answer
25
views
Unable to set default on JSON column in mysql 8.0.31
I'm trying to set a default for a new JSON column in a mysql 8.0.31 db. As far as I am aware, this wasn't possible till version 8.0.13. Starting with version 8.0.13, it should be possible to set ...
0
votes
1
answer
17
views
php container unable to reach mysql within teamcity pipeline
I recently tried to migrate my pipelines to teamcity for a project but ran into issues with my pipelines within teamcity not being able to connect to my mysql container.
It's a hard requirement to use ...