Questions tagged [database]
A collection of data that is usually organized into tables for different data objects. Tables usually consists of records on instances of the data objects.
867 questions
0
votes
0
answers
45
views
How can I sort our library's text report about books so that pulling them is more efficient?
TL;DR: I work at a library and we run a daily report (see below) to know which books to pull off shelves; how can I sort this report better, which is a long text file?
I work at a library. The ...
-3
votes
1
answer
121
views
Matching and confirming combination of data from different columns, where data could be exact or an approximate match
I have a case, I am not sure if its possible to solve, but I will appreciate any help or some sort of workaround. I need to compare combination of data from columns A+B with combination of data from ...
- 71
0
votes
0
answers
88
views
Installing Perl DBD-Mysql on Windows 11
I can't get DBD-mysql to install on my Windows 11 machine.
Activestate Perl 5.40.2
DBD-mysql version 5.013 (Auto)
Mysql server 8.4
Mysql server is running.
Database 'test' has been created.
...
1
vote
1
answer
89
views
Matching combination of data from different columns and rows / looking for a specific result
I have posted a similar question previously, but now I am adding some additional conditions.
I am trying to figure out the following:
Columns A and B contain a combination of data in each row (for ...
- 71
4
votes
2
answers
243
views
Comparing a combination of data from two columns to another combination from other two columns
First: I am trying to match a combination of data from columns D:E with a combination of data from columns A:B (Example ss per the screenshot: if the combination of data from columns D+E[Row 2] ...
- 71
1
vote
0
answers
119
views
Why can’t I permanently delete phantom MySQL tables in phpMyAdmin after a MySQL crash (XAMPP / InnoDB)?
After a MySQL crash in XAMPP, I'm encountering a persistent issue where certain tables in phpMyAdmin reappear after being deleted. These "ghost tables" cause conflicts when I attempt to re-...
- 257
0
votes
2
answers
120
views
Is there a MS SQL wrapper / converter interface for a Postgresql database? [closed]
This is kind of an exotic situation: We have a very specialized and old .NET application (without sources) that connects to a MS SQL Server database. As there are certain restrictions for the "...
- 620
1
vote
1
answer
81
views
How to explore folders of a web directory in the terminal?
I am analyzing some data using my university SSH server. Some new data was shared with me in a web format (share.servername.com/url/XYZ/abc/…).
The page includes multiple folders and subfolders. I ...
- 111
0
votes
1
answer
64
views
how to query a field for all inputs?
This use to be more common, and something i never understood. Sometimes, when clicking in a field on a site; the field will put the terms, keywords &or phrases into what i can only think of as ...
0
votes
0
answers
70
views
Microsoft-Access: Unable to save form data into Table
New With Ms Access want to create a little Database for shop.
Here is My Form structure Based on Table "Sales".
Label Name
Customer Name CustomerID(Combo Box)(FK)
Product Name ...
- 5
0
votes
1
answer
87
views
MS Access: How to insert and manage multiple data under 1 customer
We have a milk shop. Many of our customers borrow milk and pay on a monthly basis. In Excel, we were managing the data, now we want to do it in Access. I can't explain this data format by writing it ...
- 5
0
votes
0
answers
74
views
Why does my formula only match some values and not others?
I tried cleaning up my data, used special paste (values only). Did the ERP software (LN) do something to it so it's harder to copy and edit? Can somebody make the data work? Formula works fine with ...
0
votes
0
answers
281
views
Podman container with mediawiki can't connect to mariadb
I have a podman container with a mediawiki inside and a mariadb natively installed. So far it is running and I can access the web-interface.
But when I try to connect to the database during the setup ...
- 113
0
votes
0
answers
31
views
Summary sheet data colation
I’m working on an Excel workbook that has data spread across multiple sheets (e.g., "Coal", "Steel", "Turbofuel", "Computer"). Each sheet contains arrays of ...
- 1
1
vote
0
answers
347
views
Database + BTRFS killing HDDs?
A database* will generate many small writes to its storage. If the storage is backed by a BTRFS filesystem, then these small logical writes will lead to many larger writes because of BTRFS' copy-on-...
- 343