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 ...
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.
...
-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
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
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
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
6
votes
1
answer
8k
views
What's the database format for WhatsApp Desktop for Windows?
I'm trying to extract all of my WhatsApp messages with metadata for analysis, searching, graphing, e.t.c. Extraction of the Android database requires rooted access, so I'm trying to use the database ...
- 296
4
votes
3
answers
20k
views
Postgres docker error "data directory "/var/lib/postgresql/data" has wrong ownership"
I am trying to start a postgres container using docker
I have tried using multiple versions of postgres docker images
I have tried using volumes as mentioned here
tried setting POSTGRES_USER ...
- 80
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 ...
2
votes
3
answers
24k
views
MongoDB error - Failed with result 'core-dump'
I need help with MongoDB. I am running Ubuntu Server 22.04.3 LTS (Jammy). When I run systemctl status mongod, I get this:
× mongod.service - MongoDB Database Server
Loaded: loaded (/lib/systemd/...
- 23
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
94
votes
8
answers
147k
views
"FATAL: lock file "postmaster.pid" already exists"
I just reinstalled postgres via brew install postgres
I ran initdb /usr/local/var/postgres -E utf8 but got this:
The files belonging to this database system will be owned by user "atal421".
This ...
- 1,103
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