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
27
questions
0
votes
0
answers
5
views
SQL Inner join with where clause works fast with one condition, but not when activeFlag is added
I have a query like
select C.customerId, C.firstName, C.LastName, R.IsActive from
Customer as C
Inner join Rider as R ON R.customerId = C.customerid
where R.rideid = 'xyz' and
R.rideareacode = 'abc' ...
0
votes
2
answers
12
views
PHP variable 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="...
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 ...
-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 ( ...
0
votes
0
answers
26
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 ...
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
40
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
21
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 ...
0
votes
0
answers
36
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 ...
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 ...