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,198
questions
-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 ...
2
votes
2
answers
63
views
How can I set a numeric wildcard in MySQL? [duplicate]
I'm trying to create a SQL script that finds codes in two different databases. I want to set a parameter that has a numeric wildcard.
Codes are often written like this for example, ABC108, ABC109, ...
0
votes
1
answer
37
views
Unable to make a remote api call to flask app(for MySQL connection) inside my apache server
I have an apache server running on Alma Linux. I have the flask code setup to accept API calls from remote connections. So my API call hits the flask which then connects to MySQL database.
When I try ...
-1
votes
0
answers
29
views
Trying to connect a client OrangePi Zero to a remote my PC's remote server [closed]
I have a flask project which basically fetches state changes of 4 entries from a MySQL database in a MySQL server which runs locally and display them on the dashboard which also runs locally.
This ...
0
votes
0
answers
11
views
Error Unable to cast object of type 'System.Int32[]' to type 'System.IConvertible' when calling Stored Procedure in MySQL
The Error says that Unable to cast object of type 'system.byte[] ' to type 'System.IConvertible' in the ExcecuteNonQuery(). What should I do? Anyone....
Details: HeidiSQL, and MySQL 5.0.96
public ...
0
votes
1
answer
27
views
How to Handle Indexes for @MapsId in JPA: Should FK and PK Share the Same Index?
I am using the @MapsId annotation in JPA to map a foreign key (FK) to a primary key (PK). According to the @MapsId annotation, the FK and PK share the same value. However, when I checked the database ...
0
votes
0
answers
25
views
Unable to insert Mirth logs in MySql DB using log4j 2.17.2 JDBC appender
I'm using Mirth Connect, which uses log4j 2.17.2. I have tried to insert Mirth logs in a MySql DB using the log4j2 JDBC appender but failed to do so. Mirth Connect runs and logs to the dashboard and ...
-2
votes
0
answers
39
views
is there a way to store unschematised datas in sql database [closed]
mysql : 5.6 java : 11
Am in need of an mechanism to store unschematised data in my db. the case is as follows.
Objective :
To get all user from a 3rd party app and store it in db.
Problem facing :
...
0
votes
2
answers
34
views
Weighted hierarchical cumulative sum
I don't know if I'm using the correct terminology, but I'm trying to find the cumulative sum of each node in a tree structure, but the children node only contribute a percentage of its cumulative sum ...
0
votes
0
answers
25
views
Node zlib: throwing incorrect header check while inflating or unzipping
I have a varbinary type column jsonBin in db. I want to store json (string) which is compressed using zlib.
zlib.gzipSync(data) or zlib.deflateSync(data) returns buffer object.
If I use base64 ...
-3
votes
0
answers
18
views
MySQL data to OneDrive [closed]
We are using windows server and scheduled phpscript to extract MYSQL data and load into csv file, then upload it to Onedrive. However this process in the recent days seems to be troublesome.
We are ...
-3
votes
0
answers
40
views
data cant be save in database [closed]
i have a registration form and i want to store the information (gender and phone included) but it didnt store in the database even the register is successful but the column for gender and phone_number ...
-3
votes
0
answers
25
views
What is the best way to implement these relations in DB? [closed]
Movie
Stores:
Title
Description
Potentially huge text with a detailed description of the movie
Budget
Release date
Duration
Character
Stores:
Name
Description
Role (Valid values — leading, ...
-2
votes
0
answers
27
views
Laravel 11 Eloquent subquery statement failed [duplicate]
Please help with this subquery to transpile to Eloquent sentence:
SELECT * FROM notifications WHERE id NOT IN (SELECT notification_id FROM notification_seen WHERE user_id = 1)
Sql sentence works ...
0
votes
2
answers
33
views
Using multiple tables for lookup in MySQL
I'm normally pretty good at finding the answer I need by searching, but I'm drawing a blank on this one.
Let's say I have two tables that both have a list of names and ID numbers (we'll call them a ...