657,152 questions
Score of -4
0 answers
51 views
FEDORA Can't run sudo systemctl enable --now mysqld "Job for mysqld.service failed because the control process exited with error code. " [closed]
Because I tried to reinstall mysql I encountered a strange error. I dug around until I realized that instead of a plugin password problem, I started getting an error when running sudo systemctl ...
- reputation score 1
Score of -4
2 answers
181 views
Can I perform a (LEFT) JOIN with a potentially not-existing table?
I need to join a table, that might not exist. Is it possible to specify a condition in the query, so that the join is only performed if the table actually exists? My idea would be that the ...
- reputation score 536
Score of -4
1 answer
123 views
Is it possible to store the definition of a table in a database?
I can of course create a table with SQL. But is it possible to only define the structure (including specified types, primary keys and constraints), so that later only the table name needs to be ...
- reputation score 536
Score of 0
1 answer
251 views
Connect SQL to Java without displaying the password [duplicate]
I'm just starting to learn SQL in Java, and I'd like to know how I can connect my SQL database to Java without having to reveal my password. I'd really appreciate your help.
Basically, I need to ...
- reputation score 25
Score of 0
2 answers
189 views
Operation not permitted on mysqli_connect()
I have the following code and it was perfectly at least for a year. Two months ago the query inside the main query after 19th row main row crash with the following message:
Fatal error: Uncaught ...
- reputation score 19
Score of -2
2 answers
116 views
How to use images when it comes to SQL databases? [duplicate]
I´m developing a database using MySQL for a food delivery website, and I want it to have pre inserted items and also the option to insert new products. How do I store the images? I read that you can ...
- reputation score 7
Score of -6
1 answer
155 views
Laravel Eloquent whereHas() query is slow with large datasets [closed]
I’m working on a Laravel application using MySQL where I need to filter products based on related records. The query works correctly but becomes slow when the database contains a large number of ...
- reputation score 1
Score of -2
1 answer
120 views
Running MySQL get results and exit [closed]
I want to run MySQL to test the connection from my C++ code so if I get a connection the process should just exit.
Is there an option to do that? Or it will detect it automatically?
I'll be running it ...
- reputation score 6498
Score of 1
2 answers
159 views
Selecting non blank data in aggregation query
I have a table with some order data in it: A simplified summary is like this:
OrderNum
Revenue
Payment
RecordType
OrderData
1
30
0
Order
Shirt-Size:Large
1
0
30
Payment
2
20
0
OrderAmended
T-Shirt:...
- reputation score 95
Score of 2
1 answer
389 views
Chance of conflicts using stateful classes
TL;DR: is it a bad practice to use a stateful JS class?
I am building a website using Node.js and Express, using MySQL as my DB.
To use the DB I have made a simple CRUD MySQL ORM to retrieve and save ...
- reputation score 92
Score of -1
1 answer
160 views
Insert record with foreign key if primary key is missing or not?
I have two tables with a primary-foreign key relationship.
A value in the foreign key table must be present in the primary key table.
What is a stored procedure to insert a record into the foreign key ...
- reputation score 73
Score of -2
1 answer
235 views
Is replaying a transactional outbox in auto-increment ID order will maintain the order of events?
I'm implementing a transactional outbox pattern and trying to replay events in order.
After outbox events are published, they are stored in an inbox table on the destination. A separate process ...
- reputation score 2475
Score of 2
1 answer
126 views
LOAD XML SET field name with minus
Taking the example:
<?xml version="1.0"?>
<employee person_id="1" f-name="Kapek"></employee>
<employee person_id="2" f-name="Sajon&...
- reputation score 43
Score of 0
1 answer
243 views
Error Code 1054 unknown column in 'field list' error without Group Concat Actor [closed]
I am playing around with the Sakila database. There is a view in this database named film list.
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `sakila`.`film_list` AS
...
- reputation score 9
Score of -1
0 answers
178 views
Is a hand-rolled CASE expression a reasonable way to do relevance-ranked search with JPA Criteria API + MySQL, or is there a better approach?
I'm building a company search endpoint in a Spring Boot app (JPA Criteria API, MySQL) where I want exact matches to appear before prefix matches and before substring matches when a user searches by ...
- reputation score 11
