30 questions from the last 30 days
-2
votes
0
answers
16
views
Where can I manage my database when running Laravel without XAMPP? [duplicate]
I just realized that Laravel can run without starting XAMPP, which confuses me. I’m used to monitoring my database through phpMyAdmin, but since I don’t run XAMPP when using Laravel, I’m not sure ...
Advice
0
votes
1
replies
57
views
How to Automate Extraction and Standardization of Multilingual Name/Username Data Without Modifying the Original Database?
We’re working with a user table populated from multiple SSO sources, and the data has inconsistencies that hinder generating standardized names. I need a persistent, automated way to extract and ...
- 17
Advice
0
votes
8
replies
128
views
How to make it so a parent NEEDS its children to exist in MySQL?
I am designing a DB where basically parent can't exist without two children. E.g: Entity set Marriage, CAN'T exist without entity set Man and entity set Woman, but neither Man or Woman need Marriage ...
- 21
0
votes
1
answer
50
views
AWS Glue Script Scanning Entire Table Despite Date Filter
I have written a small Glue script that fetches some data between two dates, but I found that it scans the entire table instead of just the data within the specified time range. I also tried creating ...
Best practices
1
vote
6
replies
120
views
Best way to get a number of list elements whose sum of values equal a constant value
I have a list which consists of numeric values.
In Python, it is written as:
[959, 3480, 9346, 8367, 2847, 8330, 6946, 9586, 9722, 2775]
Or in the case of MySQL:
create table testtb(n int);
insert ...
- 2,217
Advice
0
votes
8
replies
138
views
MySQL dump from Ionos server not compatible with dockered MySQL db
I am trying to set up a development and testing environment for the software of my new employer.
The data is quite complex and due to some shortcuts/bad architecture decisions of the company that ...
- 31
0
votes
0
answers
55
views
dbt-core having issues with establishing connection with mysql
I have a dbt-core setup to connect to mysql database which is installed on a localhost on my personal machine. The connectivity from dbt-core to mysql was working fine until I recently upgraded dbt-...
0
votes
0
answers
28
views
MYSQL generate row for month data without entry [duplicate]
I'm writing a program to count attendance, and I have a table (att_events) containing the holidays in this format:
Date | Description | Poster ID
2025-01-01 New Year Admin
by using the ...
1
vote
1
answer
62
views
An alias is giving different result in MySQL [duplicate]
Can someone explain why I'm getting two different results from the below two queries?
Q1:
SELECT match_no, COUNT(*) as "number of cards"
FROM player_booked
GROUP BY match_no
ORDER BY "...
- 21
-8
votes
1
answer
120
views
ERROR 1064 (42000): You have an error in your SQL syntax; Getting error for adding foreign key after creating table [closed]
I created 2 tables students and course, in course I want to add student_id as foreign key but I am adding the key after creating the table and it is showing error. Need help in solving this thing.
...
Best practices
3
votes
1
replies
107
views
Architecture design for multilingual descriptions for several classes
I am creating an E-Commerce app. It has Category and Product classes. Both have multilingual descriptions, so, tables with title, description, meta-*, etc. and unique key (id, language_id).
To add ...
- 178
2
votes
1
answer
60
views
Join Query with an Aggregate Function (number of bowl games won for colleges that have won at least once)
I'm working through my Data Management Applications labs and I'm stumped on one particular lab. I'm definitely missing something incredibly obvious, and I'd rather look dumb on the Internet than look ...
- 23
0
votes
0
answers
65
views
Mysql create a view for Power bi
I would like to create a view in mysql who show the place of my order as text. This place is a json object (example {"sap_hold": 1, "in_licensing": 1}). I would like to add a ...
- 414
4
votes
1
answer
131
views
Spatial index will not be used 'cause it has no SRID attribute
I am very confused now, because I cannot get this to work. I have a tbl_address which already has longitude and latitude. I want to add a spatial index for my search. So I want to add a location POINT ...
- 1,092
3
votes
1
answer
110
views
bash script concat() in prepared statement for mysql
This gives a syntax error:
read -p "entry: " entry
sql="select concat('entry ', id) from mytbl where id = ?";
$mysql_conn "prepare stmnt from '${sql}'; set @id='${entry}';
...
- 109