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
661,941
questions
0
votes
1
answer
6
views
PHP varible from mysql query in form, when null
I have an html form used to edit a record in a mysql table.
In the case of editing, I prefill the form with the current values for the record as returned by the query, as below:
<INPUT TYPE="...
- 155
0
votes
0
answers
12
views
How to allow customers to update their sales channel in admin interface in a Shopware 6 plugin?
I'm working on an e-commerce platform where customers are assigned to sales channels. Currently, this information is stored in the database, but can only be updated through direct database queries. I ...
- 125
-1
votes
1
answer
25
views
laravel model pages not communicating properly
Working on a client project, hit a setback.
Laravel is reading
"Call to undefined relationship [service_item] on model [App\Models\Service]".
It's simply trying to read data from two ...
-2
votes
0
answers
19
views
Laravel 10 migration data type ( Exg : text, string, longtext ... Etc.) size list in charector and size(kb pr mb)
Laravel 10 migration data type (Exg: text string longtext etc.)
Data type
size KB (char)
String
xx kb (cab)
Text
xy kb (acb)
Can anyone share this list.
A list of data type and it's sizes ( ...
- 1
0
votes
0
answers
25
views
Python script gets stuck due to mysql query running for longer period
Mysql version - 5.7
Python version - 3.9.2
I have a dynamic mysql query, which sometimes runs for over 10 mins or something and the mysql's set timeout has been set to around 1 minute. Which is why i ...
0
votes
0
answers
17
views
How to merge multi schema data into single schema in mysql?
I have one application with multi-schema and single schema both running on differnt server.We use MySQL database with multiple schemas, each containing several tables, stored procedule and other ...
- 41
0
votes
0
answers
24
views
docker-compose generated WebAPI container fails to connect to MySql container
I have a Visual Studio .Net 8 Solution that contains a WebAPI backend project. It also contains dockerfile. I have also added a docker-compose to orchestrate the project. Outside of this visual ...
0
votes
0
answers
13
views
Unable to Export Data In Hindi (Unicode) Excel using PHP and MySqli
Unable to Export Data In Hindi (Unicode) Excel using PHP and MySqli
Below is the code im using to export data from the database & its working fine but when i try to export hindi entries excel ...
0
votes
2
answers
39
views
Select user's high score for each lesson from one table based upon lesson ids in another table
I have a site that has multiple courses and each course has multiple lessons. I would like to select the highest score per LESSON for a given user_id and course_id ordered by lesson_order.
TABLE ...
-2
votes
0
answers
20
views
insert in to target table and avoid the rows with same set of column value from source to target [duplicate]
-- Create a temporary table with sample data
CREATE TEMPORARY TABLE temp_student (
roll_no INT,
name VARCHAR(50)
);
-- Insert some sample records into the temporary table
INSERT INTO ...
0
votes
2
answers
26
views
Connecting to local mysql server from within a docker container [duplicate]
I'm running a go app locally (MacOS Sonoma) that connects to a local mysql server. This works fine when I build the app and run it from the command line. When I create a container and run it - all ...
- 1,247
0
votes
0
answers
32
views
How to Use a Single INSERT INTO Statement for Multiple Rows in Python?
I’m currently working on a Discord Python bot where I loop through a list of ForumTags and generate an INSERT INTO SQL statement for each object to insert data into a MySQL database.
However, I want ...
- 767
0
votes
0
answers
17
views
Flask-MySQL Python long request
I'm using Flask to create an API. I need to make a query to the database and for this I used the flask_mysqldb library
The fact is that before that I used another library (mysql.connector) and my ...
-1
votes
0
answers
27
views
MySQL Server 8.0.39.0 configuration fails at "Starting Server"
I was installing MySQL installer recent version 8.0.39.0 on my Win10 pc. During the server configuration process, it gets stuck at "starting server" and doesn't move any further.
enter image ...
0
votes
2
answers
45
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
...
- 347
0
votes
1
answer
38
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
30
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 ...
- 15
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 ...
- 9
-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
...
- 1
-7
votes
0
answers
33
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 ...
- 3,805
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 ?
- 3,805
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": "लक्समी नगर&...
- 334
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'...
2
votes
0
answers
56
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 ...
- 23
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 ...
- 11
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 ...
- 11
-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 ...
- 1,124
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 ...
- 1,302
-3
votes
0
answers
19
views
Data Import in mysql [closed]
i am facing this issue while facing this is importing CSV in Mysql
i have importing data from excel through import and tried to change the date format but it doesn't worked so any guidance would be ...
- 1