Questions tagged [database]

A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information.Use this tag if you have questions about ...

0
votes
0answers
8 views

Array handling in mongodb

I have the following two objects in my mongo db.{"schema":{"tag1": [{"path": "/homeAddress","sourceId": "1234"}],"something1": [...
0
votes
0answers
5 views

Types of tests for databases

Regards!I am doing a comparative study between MySQL and MongoDB, I have already done performance tests (CRUD) but it turns out that now I must expand the study and perform other types of tests of ...
-1
votes
0answers
12 views

Having trouble normalizing this simple database to 3NF

I have been attempting to normalize a small database I am using as part of an assignmentI have created a diagram of my databaseMy first table stores information on a user account - user_Id (the ...
-1
votes
0answers
14 views

How to determine Functional dependency if a table is given

Can anyone please explain how I can find functional dependency if I've been given a table with some dummy data. Below is a table. Can anyone please explain what are the functional dependencies in ...
1
vote
2answers
15 views

Making the values of a drop down the values of a txt

i need some help going line by line in a text file then making those lines the values for a drop down box, here is what i have got so far but i don't think this is close to correct. Any help would be ...
-1
votes
1answer
28 views

Need advice in changing MySQL connection options (Python)

I've been stuck for a few days trying to run some code in MySQL to fill a database that I have already created. Initially upon running I got the error :"Client does not support authentication ...
-1
votes
0answers
14 views

How to get all records from DB using java hibernate?

I have code which works correcly but takes only one record from DB (table name customer).So that line works fine for single records:Customer customer=session.get(Customer.class, 1);How to get ...
0
votes
0answers
15 views

ISNULL()/ISNULL() for retrieving data from fields that moves between tables?

Currently I'm working on a project to track some data through a few database tables. The nature of the data is as such: as the data is processed by different people, it moves between different tables ...
-2
votes
0answers
13 views

encrypted XML file

I have this case:every user use GUI interface to load his XML file . i have to display this XML file and encrypt it ,store into the encrypted XML file into data base and do the hash (SHA or any ...
-2
votes
0answers
26 views

How to check the current time of the host

After I insert the timer inside mysql, (inserttime) how can I check with php the current time in the hosting pc. I need it to do:if $currenttimeofhost=$dateHow to define $currenttimeofhost?
0
votes
0answers
17 views

How to set a PHP SESSION_ID using a MySQL Database

I'm trying manage my users PHP SESSIONS using a MySQL database. I am setting the SESSION_ID() manually using the ID primary key field in the database so its unique to each user.The API i have ...
-1
votes
2answers
28 views

Comapring rows with column values in SQL Server

I have to compare a row (in Table1 and Table2) with columns (Employee, Place from Table3) and check values are matching or not. I am using SQL Server 2017For example, Table1:Table2Table3...
0
votes
0answers
12 views

MongoDB and PHP installation error

I'm trying to create a project with PHP and MongoDB but when I try to install the dependency using compomposer install mongodb/mongodb I get an error:Problem 1- mongodb/mongodb 1.3.2 requires ...
0
votes
1answer
36 views

concatenate String with Int in column

I need to dynamically loop through column names and fetch the records.Below is my table, and I am using SQL Server 2017.-- DECLARE @cnt INT=1;-- WHILE @cnt < 3-- BEGIN-- SELECT 'Name' ...
0
votes
0answers
17 views

Delete duplicate values and replace with null (Power BI - SQL)

first post :P. Anyway, so I am currently experiencing a problem after joining two tables in order to create a fact table. I did a left outer join on the OrderDetail table with the SalesOrderHeader. ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,