All Questions
49,222
questions
-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
0
answers
38
views
i dont know how to display the discussion according the id [closed]
as the title said, I already changed a lot of code but I also cannot display the discussion that users who post by themselves according to user_id in my discussion database. I can display all the ...
- 1
-2
votes
0
answers
52
views
Database programming with Delphi [closed]
so at my intern im learning delphi and i am supposed to be somewhat good at using mysql and delphi together to make apps. my intention is to learn delphi amd be able to use it to some degree but i ...
- 1
-1
votes
1
answer
41
views
How can I get a separated row instead of a CSV concated group?
I have the following query:
SELECT GROUP_CONCAT(p.name) AS names
FROM cte t
LEFT JOIN products p
ON p.tag_id = t.id
GROUP BY t.orig_id
HAVING SUM(t.id = 6) > 0;
It returns something like this:
...
- 6,575
0
votes
1
answer
36
views
SQLAlchemy delete Method: Valid Strategies for synchronize_session in Bulk Deletion
I'm working on a FastAPI project where I need to perform a bulk deletion of jobs using SQLAlchemy. The list of job IDs to be deleted is provided via a POST request from Postman. However, I'm ...
- 139
0
votes
0
answers
23
views
1:Many join question for condensing the many set by a value and ordering it [duplicate]
Trying to write a query to join to tables 1:Many and order by the date column descending so we only get a 1:1 record, with the latest many record sorted by date.
Table 1
Id
Name
Table 2
Id
Value
Id, ...
- 181
0
votes
1
answer
44
views
indexing is not working properly after upgrade mysql 8.0.28
The issue is coming after up gradation of mysql 8.0.28. I have a table called user_products. When I run the EXPLAIN SELECT query on it, the possible keys identified are user_id, productId, status, ...
- 49
-3
votes
1
answer
36
views
MySQL Performance Issue: Initial Query Slow After Period of Inactivity but Fast on Subsequent Queries
I'm experiencing a performance issue with MySQL when deploying my application to a live server. The problem occurs when creating a short link for the first time after a period of inactivity. ...
- 11
0
votes
0
answers
16
views
Error in sql trigger: You have an error in your SQL syntax [duplicate]
CREATE TRIGGER UpdateBalance
AFTER INSERT ON Transactions
FOR EACH ROW
BEGIN
IF NEW.TransactionType = 'Deposit' THEN
UPDATE Accounts
SET Balance = Balance + NEW.Amount
...
0
votes
0
answers
27
views
How to show posts to user based on likes and comments by following account?
i am making website using laravel and want to add functionality where user can see those posts which are liked or commented by those accounts which are followed by logged in user and exclude posts of ...
- 9
0
votes
0
answers
30
views
Connection Error "Access denied for user 'root'@'172.19.0.1'" When Connecting to MySQL Docker Container
I'm having trouble connecting to a MySQL database running inside a Docker container. Here's the setup:
I have created a MySQL Docker container with the following docker-compose.yml:
version: '3.8'
...
0
votes
0
answers
18
views
I need help to create a complex mySql query that involves JSON and JOIN statement between 3 tables
These are my tables:
Students
studentID
name
xk341
XeraKay
kj403
KevinJo
Terms
studentID
year
term
startDate
endDate
xk341
2019
1
2019-09-01
2019-12-24
xk341
2019
2
2019-01-01
2019-03-05
...
- 1
0
votes
0
answers
18
views
Mysql Left join with latest one record only from right table without turning off strict mode [duplicate]
I have 2 tables; I need join all cars and their users who has user.car_status = 1, but only with latest user.
I know it can be achived by turning off the above mode and there might be similar ...
- 8,039
0
votes
1
answer
57
views
How can I find the longest number of consecutive nulls in a column in MySQL?
Supposing I have a table consisting of something like:
date | A | B | C |
02/01/2020 | 3 | 5 | null |
03/01/2020 | 8 | 3 | null |
04/01/2020 | 3 | 4 | null |
05/01/2020 | 5 | 9 | 3 |
06/01/...
- 3
0
votes
1
answer
45
views
MySQL Error Code: 1411. Incorrect datetime value: 'date' for function str_to_date
I'm attempting to change the date format from MM/DD/YYYY to YYYY-MM-DD.
Code:
SELECT `date`,
STR_TO_DATE(`date`, '%m/%d/%Y')
FROM example_table;
Results(success):
date ---> STR_TO_DATE(`date`,...
