657,196 questions
Score of -2
0 answers
110 views
Server and Database Options for a Wordpress.com Website? [closed]
I made a website with Wordpress, hosted by Wordpress. I need my website to be able to access and use data from a database and I have tried multiple options and there have been issues with each one.
...
- reputation score 23
Score of -4
0 answers
93 views
Error Code 1064: Error in Line 6 with '?' [closed]
SELECT t.technician_id, emp.full_name,
GROUP_CONCAT(DISTINCT sp2.specialism_name ORDER BY sp2.specialism_name SEPARATOR ', ') AS skills,
SUM(CASE WHEN c2.status = 'Open' THEN 1 ELSE 0 END) AS ...
- reputation score 1
Score of -2
3 answers
96 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 5
Score of -6
1 answer
121 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
111 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 6506
Score of 1
2 answers
149 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
188 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 94
Score of -1
1 answer
153 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
193 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
94 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
215 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
126 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
Score of 3
1 answer
169 views
Find identical aggregated combinations from pivot table in SQL
Background
I’m updating a very old website which has a tagging feature for objects. The tags are divided into nine separate semantic categories and can be related to objects via a pivot table. There ...
- reputation score 972
Score of 0
0 answers
173 views
How to design a zero-downtime schema migration strategy for a high-traffic Laravel/MySQL application with hundred of millions rows?
I am designing a Laravel application that handles millions of daily requests with a MySQL database containing tables with hundreds of millions of rows.
A common requirement is adding or modifying ...
- reputation score 1
Score of 0
2 answers
216 views
Concat multiple row values into for a single empId
Like I have user Data 50 emp inside each user has different skills 3 rows same user but skill column value is different
I want to concat the skill and display in single row for each user don't want ...
- reputation score 1
