Most voted "database" questions
A database (its abbreviation is BD, DB, database) is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If this is a specific database management system, like Mysql, for example, use this tag instead.
Learn more…3,414 questions
Sort by count of
-
0
votes0
answers422
viewsPgadmin4 - Empty Data Output
I installed Pgadmin 4 on my machine with windows 10 64bits, I configured the server, but when I open some table the query seems to run normally, but the tab "Data Output" shows nothing, neither…
-
0
votes0
answers90
viewsPost in table N:N with Node.js and Angularjs
I have a relationship N:N and 3 tables: projeto, pagamento and projeto_pagamento. In a form, I want to register a project and 5 payments, which would be the best way to perform this insertion? I…
-
0
votes1
answer150
viewsQuery is returning an empty array (Mysql/Wordpress)
How do I get the field values meta_value = candidate of this table. I’m using this query, but it’s returning an empty array. $resultados2 = $wpdb->get_results( "SELECT * FROM $wpdb->usermeta…
-
0
votes1
answer165
viewsDoubt to get the id of a different Php and Mysql table
How do I save the id of a different table within a select ? Code below <div class="medium"> <span> <select name="turma"> <option>Selecione a Sala</option> <?php do {…
-
0
votes1
answer31
viewsUnexpected Result in SELECT
I have a SELECT that does Join in three tables, taking order data, requested client, responsible assistant and values related to orders. all the Clientes and Assistentes duplicates in that query are…
-
0
votes1
answer664
viewsQuery to separate records
Good afternoon guys, I’m having trouble performing a query. Have the following table I would like to make a query that shows which and how many status_telefonia had by phone and date, then create a…
-
0
votes0
answers70
viewsFilter Data to Database
Good afternoon, I have a problem that I hope someone can help me with. I needed to pass about 700 entries to a database (in this case Sqlite Studio) but I can’t find a way to filter those 700…
-
0
votes0
answers298
viewsShow Jprogressbar while connecting to database
I have a java desktop application with netbeans connecting via JDBC, and I have a class that connects to a database and returns some items that are stored there. I’d like to exhibit a progressBar As…
-
0
votes0
answers186
viewsRecover Database data to Android using php!
I need to retrieve the name, message, lat, long data from php. The problem is being in the part of Android, what I need to do to recover this data from the Activity "Android Part" saving these in…
-
0
votes1
answer389
viewsProblem creating a database diagram in Visual C# 2010 Express
Even creating a table called "People" previously, when creating a new database diagram in Visual C# 2010 Express, there is no table option for me to work on, not even the "People" table I created…
-
0
votes1
answer342
viewsTake mysql data and use in Mapsfragment on Android
My part of php I believe is working. I don’t know how to get this data to Android. How can I do? I need to pass the name data,message,lat,long for some variable on android. Part in Php: $sql =…
-
0
votes1
answer192
viewsPHP - How to navigate a radios array?
I have the following code: <?php while($row = mysql_fetch_array($alunosTurma)){ ?> <tr> <td><?php echo $row['NM_NIS_ALU']; ?></td> <td><?php echo…
-
0
votes0
answers108
viewsSearch in Oracle Bank losing session
Good morning dear friends, i am having serious problems regarding using Oracle database and losing session. The scenario is as follows: of thousands that you want to accomplish, some of them crash…
-
0
votes1
answer99
viewsHierarchical database(?) - Sqlite/Android
Good afternoon, I’m starting to study Android and thought of making an app to already study together database. I want to make a "family tree", so that clicking on the person’s name (button) would…
-
0
votes1
answer388
viewsPHP; Mysql; calculate/ insert data automatically according to certain parameters
Good afternoon, I have 3 tables. I want to calculate and automatically insert the schedules in the scales table according to some parameters. ex: 4 days working mornings, 2 days off, 4 days working…
-
0
votes2
answers246
viewsSet connection according to logged user data
I created a second connection in my config/database.php file and I will also create a third one, I wanted to know how to switch between these connections according to the logged in user.…
-
0
votes0
answers35
views -
0
votes1
answer408
viewsHow to print current form in MS Access?
Using a rotary pushbutton, I want to print the current form in MS Access in a database.
databaseasked 7 years, 8 months ago Luis Euegenio Riquelme Pino 1 -
0
votes0
answers157
viewsWhen I give select in any table of my FIREBIRD bank , I can’t "decipher" the varchar
So, I’m having trouble with this bank, I try to give a select . in any table I give select the varchar look like this as you can see . I already changed the charset for everything wants way and…
-
0
votes1
answer577
viewspostgres compare time extracted from a timestamp
I need to extract the hours and minutes of a timestamp in mysql, I tried to use maketime(); CREATE OR REPLACE FUNCTION agendar(dia timestamp) returns bool as $$ declare hora time := extract(hour…
-
0
votes0
answers55
viewsForeign key error in SQL
The error is in the last two lines. Whereas code is primary key of city and acronym is primary key of sector. CREATE TABLE funcionario( codigo int NOT NULL, nome varchar(30) NOT NULL, sexo char,…
databaseasked 7 years, 8 months ago Gabriela santa clara 41 -
0
votes1
answer106
viewsEncrypt critical data in the database
Thinking about security, and minimizing the problems in case someone disabled can have remote access to the database server, I thought to encrypt the critical data. Critical data examples (defined…
-
0
votes0
answers66
viewsmysql error while trying to insert a timestamp
I’m trying to pass a timestamp per parameter for a Function, but I end up getting an error ERROR: invalid input syntax for type time: "10" the stretch where I pass is: select agendar('2010-01-01…
-
0
votes1
answer687
viewsMYSQL extension error
I set up a code page on my site that looks for information from the database but in the file that connects to DB and pulls the pertinent information this giving a supposed extension error. This…
-
0
votes0
answers58
viewsSelect last conversations by counting unread messages in each conversation
I have done a chat in Nodejs and I can already bring the list of conversations. However, I also need to bring the amount of unread messages from each conversation. Currently this query brings the…
-
0
votes1
answer294
viewsID sequence advances +1 during error [Postgresql]
I have the following table in the database in postgresql The fact is that the column Description is unique_key so for testing issues I decided to insert some records with the repeated values in the…
-
0
votes1
answer749
viewsSaving fields with comma
What I need to do to save in a field currency-like values with the comma and send to the with the comma. As I declared the price field in the bank: preco number(12,2), Code: class clnPrato { private…
-
0
votes1
answer124
views -
0
votes1
answer625
viewsError comparing MD5 password in PHP
I’m having a problem in a login form, below follows the current codes. I’m using the method via POST, what happens is that it is not sending the post in MD5 to be compared in DB. In the database the…
-
0
votes1
answer779
viewsGeneralization in a Database
I’m modeling a job, I stumbled into a situation I don’t know how to proceed: In a Medical Clinic, a PERSON may be PHYSICAL or LEGAL. THE PATIENT, MAY ONLY BE A PHYSICAL PERSON Here comes the doubt:…
-
0
votes1
answer79
viewsData modeling with people of different profiles
I need to create a system where people can play different roles. (e.g. They can be teachers, students and server). The main information is: Teacher profile: name, address, email, area of activity,…
-
0
votes1
answer43
viewsHow can I search for a property if I don’t know its name?
In my database mongodb I am saving a document with the following structure: { "_id": "A/B", "Properties": { "Abandoned": { "TypeName": "int", "Name": "A/B/Abandoned", "Value": 2 }, "Busy": {…
-
0
votes3
answers102
viewsCheck number in database
In my database I have a table called "Matrices". In this table I record the livestock matrices I own on the farm, and each matrix has its respective number, which is stored in the "Number" column of…
-
0
votes1
answer53
viewsData Base in Excel?
Guys, I have a question. I Googled and found nothing related, but there could be someone who knows. You can put a Database () in the Excel ? I wanted to export a list of Clients I have in Mysql to…
-
0
votes1
answer64
viewsSearching for data from an ID in DB
I did a search here and on google to see if it would solve my problem without having to ask a question, but I could not find any solution. What I am trying to do is create a "related" but without it…
-
0
votes2
answers717
viewsSearch and people who have the same name, surname and date of birth
How can I perform a select on Oracle that brings all people who have the same name, surname and date of birth however, have different ID’s.
-
0
votes1
answer89
viewsQuestions with database
What is Staging Area for? Can I search Data from other systems (different databases)? What is a Data Mart? It is linked to the organization’s business sectors or processes?
-
0
votes2
answers182
viewsOracle Insert Too Many values
Personal Good night I want to insert data in a table but it presents an error "Too Many values" I will put my code for you to analyze. Insert into tab_Conta(id_correntista,id_banco,…
-
0
votes0
answers42
viewsSynchronization of Data
Good afternoon guys. I have a small problem: I created a C# application for the management of a transport company. There they asked me to also create a web page from where the customer informing the…
-
0
votes0
answers94
viewsSQL - AVG with vendor alias and grouping
I need to create a query that calculates the average of a vendor delivery "score". It follows query, and in sequence, explanation of the fields: SELECT distinct C7_FILIAL, CASE WHEN C7_FILIAL =…
-
0
votes1
answer34
viewsIdentify 3 equal results in 3 different BD mysql
I have a php application that I have created that I list several ips, on some sites that I use, I would like to list the same ips on 3 sites in a single list! How I Do? Major Problem: Database…
-
0
votes1
answer120
viewsProblems with login cookies
In the login page send the form with your login data, record the data in cookies and redirect to another page. But I am suffering problem if the user logout, I wanted to delete the cookies, on the…
-
0
votes0
answers155
viewsDatabase - Merge tables with different structures
My main question is: what is the best way to do and not which commands to use. What I need, basically, is the following: I have two tables with different structures, in different databases. For…
-
0
votes1
answer901
viewsBackup and Restore in Delphi with Sql Server how to do?
Hello I would like to know how I can do a Backup and Restore to integrate in my system. I have a code ready but is for Firebird I believe that does not fit to Sql Server. I read in some topics that…
-
0
votes1
answer329
viewsMysql - Linux installation problems
Problems with installing Mysql on a linux. Every time I put the remote in the terminal: sudo apt-get install mysql-server Return this message to me: Reading package lists... Done Building dependency…
-
0
votes1
answer105
viewsphp database modeling doubt
I’ll make a system for a colleague so I’m doubtful how I model the database I have a table with tbl_leituraAtual tbl_leituraAnterior tbl_consumo tbl_factorCorrecao = tbl_total how do I make this…
-
0
votes1
answer804
viewstransfer from one database to another
Hello guys I am developing a real estate site, however it already exists or I will just update it, my doubt is whether it is possible to transfer the properties already registered on the old site to…
-
0
votes1
answer103
viewsError searching by name Access ASP.NET C#
I have an error searching by name(value entered by user) in the access database he says that the values in the inside of the parameters are null. Follow the code. Person.Cs responsible for the logic…
-
0
votes1
answer770
viewsError 3706 Microsoft Visual Basic
I am making an application and when I went to program the VBA code to connect with Access Database which was my surprise gave the error: "Error 3706 Microsoft Visual Basic" The connection line is:…
-
0
votes2
answers753
viewsUNION with 2 DATABASES, SQL
I need to integrate 2 TABLES from DBdifferent in one DGV. I found several tutorials, but none that helped me from setting up to the connection, at least not the way I work with the connections.…