658,316 questions
0
votes
0
answers
14
views
An empty sequence is not allowed as the value of variable $attachment-mediatypes
I am using the image orbeon/orbeon-forms:2025.1-pe and using MySQL server as a database.
orbeon.xml:
<Context path="/orbeon">
<Resource
name="jdbc/mysql"
...
- 31
0
votes
0
answers
63
views
MySQL INNODB DELETE deadlock even though using indexed columns
I am getting a deadlock with the following query, and I want to know why is it happening. These queries are executed via different threads in my application, however it is guaranteed that only one ...
- 26
1
vote
3
answers
131
views
SQL procedure that won't work for some reason
I'm trying to write a simple procedure based on the MySQL database system that accepts a single string as a parameter. The procedure then splits it into shorter strings (using a separator) so that ...
- 13
0
votes
1
answer
69
views
Delete records from last day (switch midnight)
At the moment I delete records like this:
DELETE FROM users WHERE DATE_SUB(CURDATE(),INTERVAL 1 DAY)>=last_login
last_login = DATETIME field
This deletes records after 24 hours but it should ...
- 1,061
Advice
0
votes
7
replies
125
views
What are OFF.xxxxxx files in /var/lib/mysql/
I am examining var/lib/mysql/ , there are some files named OFF.xxxxxx with the xxxxxx part being an increasing number. Also there is an OFF.index file that lists those OFF.xxxxxx files.
Inside those ...
- 456
-3
votes
0
answers
53
views
SQL insert--select statement is not applying data to correct columns [duplicate]
I am making a weekly rota. I have managed to duplicate a SQL database row in a table using this code below and used a CASE expression to apply the modified data to the duplicated rows.
The problem I ...
- 61
Best practices
0
votes
2
replies
62
views
How can I recover a MySQL database from a failed Windows SSD if I can’t access phpMyAdmin?
I’m trying to recover a local WordPress project. The WordPress files are intact, but I can’t export the SQL database because the original SSD has a broken Windows installation that won’t boot. Because ...
-1
votes
1
answer
86
views
Apply a SQL Case condition to a SQL duplicated row in the same statement [closed]
I am making weekly rota. I have managed to duplicate a SQL database row in a table using this code:
$test = "2026-03-02";
$sql = "INSERT INTO myrota (weekstart, shift, employid, name, ...
- 61
Best practices
1
vote
1
replies
84
views
How to securely implement JWT authentication in a .NET health monitoring app using MySQL?
I’m developing a web application for pharmacovigilance similar to VAERS and some UN health reporting dashboards. The app is built with .NET 8, Entity Framework Core, and MySQL.Users are medical ...
-2
votes
1
answer
112
views
select count from a select? [closed]
I have a table looking like this;
mysql> describe tb_exifinfo;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------...
0
votes
3
answers
96
views
Select a single value from a group
I would like to select a single value from a group. For example:
select single(f.filename), d.id
from document d
left join document_file f on f.document_id = d.id
group by d.id
Each document ID has ...
- 79
1
vote
0
answers
121
views
Optimizing Exact Filtered Pagination Count (COUNT(*)) on MySQL with Dynamic JSON Filters in Spring Boot API
Problem Statement:
We are running a Java/Spring GET/POST getAll pagination API on top of MySQL in AWS RDS and need help optimizing exact filtered counts
Current state:
The main dataset is courses with ...
- 544
-3
votes
0
answers
62
views
Can a MySQL trigger safely call a stored procedure, and what limitations apply? [closed]
In MySQL, triggers run automatically on table events, and stored procedures encapsulate reusable logic. I would like to clarify the interaction between these two features.
Specifically:
Is it valid ...
Advice
1
vote
12
replies
102
views
Insert a new row only if a row with the same subset of values doesn't exist yet
Imagine I have a table called preferences tracking users' e-mail preferences. It has the following columns:
preferences_id (primary key)
user_id (link to the user table, not unique for various ...
- 131
-3
votes
0
answers
46
views
Free text search (first and last name) [duplicate]
I have two fields in a database, among others:
First name
Last name
There should be a search field via HTML where you can enter fragments of the name you are looking for using a free text search.
...
- 1,061
