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
votes2
answers480
viewsReturn primary key after insertion into Mysql
I need to insert into my database two tables, one of the tables has a primary key and the other will use this value as a foreign key. My question is: How can I return the value of this primary key…
-
0
votes1
answer47
viewsUpdate record five minutes after insertion
I have a table with the following structure: tb_simulation: id(INT) | codigo(VARCHAR) | flag_valido(INT) | data_hora(DATETIME) | valor(DEC) I would like that five minutes after the record was…
-
0
votes1
answer39
viewsSelect all tags separated by "," from every table
id | tags 1 | tag1,tag2,tag3 2 | tag1,tag2,tag3 In db there is the column "tags" where is "tag1,tag2,tag3..." need to show all separate tags, however shows only the first record, I would like to get…
-
0
votes2
answers3644
viewsverify registered user PHP Mysqli
Hello, I know almost nothing about Php and mysqli. I am trying to implement the user system for the site, the registration is already working but I can register with the same email as many times as…
-
0
votes1
answer304
viewsInstallment for mysql
I am making a sales system in which 1 sale generates 12 installments for 3 users, being the seller, the manager and the supervisor, I would like to know the best method for storing these…
-
0
votes1
answer71
viewsInconvergence of consolidated results x by interval
I am making a query for 10 minutes interval between date, the problem is that when I give a between to count all the results it returns a value and when I divide these values by interval and sum at…
-
0
votes1
answer38
viewsModal Does Not Return Database
I have a table in the database called pathologies. Inside this table is a column called disease. I created a modal that should return a dropdownlist with all the disease options filled in the table…
-
0
votes0
answers898
viewsSQLSTATE[23000]: Integrity Constraint Violation
I have an employee chart and address. The address is receiving a foreign key from the employee, however, is giving the following error when I will insert: Exception 'Pdoexception' with message…
-
0
votes1
answer113
viewsForm with $_files does not save the file in the site folders
Hello my projector has a form where can be sent an image, it saves the form data in the BD but does not insert the image in the files. someone can tell where my mistake is? <?php session_start();…
-
0
votes1
answer65
viewsInformation provided by the BD
Hello My project has a form that brings the BD information in case the user wants to edit, it is not changing the data, nor the image.. form: <?php $id = $_GET["id"]; //Executar consulta $result…
-
0
votes1
answer32
viewsError searching in Database
My application is integrated to my bank and makes several queries, but in one of them something unexpected is happening, because the search is not performed. Note that my instruction line is simple…
-
0
votes1
answer93
viewsWhat is the "function" in Oracle equivalent to a "set Generator"?
I’d like to know, what is the command on Oracle would be equivalent to SET GENERATOR GEN_ID_TABELA TO 5; (command made in FireBird) Because I would like to create a script with the inserts, but to…
-
0
votes2
answers495
viewsPython takes the first column value instead of the last one
I’m trying to get the last record of a column in Mysql but Python only returns "1", is an ID record with auto_incriment. I tried several ways, in some I was returned the whole column, in other era…
-
0
votes0
answers27
viewsRemove Row from table and adjust Ids
Greetings. I’m a beginner in the database and wanted to know the correct way to remove an item from the table and update the identification number of the others. This is the typical novice problem,…
-
0
votes1
answer1439
viewsPHP Read TXT, delete lines, create new file
I want to use PHP and xamp/wamp to do the following task on my computer without the need to upload/download: I have dozens of TXT files on the computer, each TXT containing only 1 name per line, no…
-
0
votes1
answer494
viewsDatabase created with Core Data on Swift
I need to create an app that is a form with basic data (name, age, email, etc.) and that saves the data for access later, but that in addition to saving in the tableView, create the database file or…
-
0
votes1
answer90
viewsComparing data returned from BD
I have a problem which is this:: When reading the data from a given Firebase node, I get an undetermined String number. The name of each String, is the ID of the User. When returning this data, save…
-
0
votes1
answer72
viewsProblem with audio in web application with tomcat7 deployment
Hello, I’ve developed a web application that requires audio. I use a javascript code to control this audio call. With the application ready, I transferred to another computer deploying in tomcat7.…
-
0
votes1
answer221
viewsError passing script from Firebird database to Postgresql
I’m trying to pass a script for creating and inserting data from a Firebird database to Postgresql, but in some tables there is a syntax error, I am using the SQL Manager Interbase & Firebird…
-
0
votes1
answer148
viewsFree DB for distribution together with commercial application
I had been reading certain licenses of some SGBD software along with the BD itself and a very confusing doubt arose. The Mariadb (Free version) it is open-source, but I could distribute it, along…
-
0
votes1
answer51
viewsDatabase Error
Every time I’m using the Delphi 6 and I go through some form linked to a database, when I run the program I compiled, it complains that the database is being used at the moment. When I close the IDE…
-
0
votes1
answer113
viewsView database data from
I want to display several data on a page but it appears only one, when instead of appearing the image of each register for example it appears only that of a which is the latest record ever made.…
-
0
votes1
answer65
viewsQuery with SQL Server query
I have the following query in SQL Server, to return me a list of cities I need. select IDCidade as "ID", case UF when 'RS' then '1' when 'SC' then '2' when 'PR' then '3' when 'SP' then '4' when 'RJ'…
sql database sql-server query sql-server-2012asked 7 years, 10 months ago Luís Felipe Dal Molin 169 -
0
votes1
answer208
viewsInsertion in Mysql via PHP foreign key
I am creating a PHP and mysql application to manage people outside my company. The logic is this already inserted the Companies that I will associate to each entity People but when trying to insert…
-
0
votes1
answer236
viewsSave data from a WYSIWYG editor to the database
I will have a "form" inside it will have a WYSIWYG like take the typed data from inside it and save in the database, because I will have text and images inside. I am developing in Ruby, and trying…
-
0
votes1
answer367
viewsOracle does not export all tables
I am performing an export by database at a time 11.2.0.1.0 but when checking the log I realize that the tables that have no record are not exported. command I’m using to export the database exp…
-
0
votes1
answer94
views$lookup no db.createView()
I have a database of two Collections: companies and people. And I want to create a view called "peopleSectors" from the collection people. db.createView ( "peopleSectors", "people", [ { $lookup: {…
-
0
votes1
answer214
viewsDblookupcombobox Doubt - Delphi 6
Good morning. I’m using Delphi 6 and I’m having a question, I have a table of students linked to a table of disciplines, and these disciplines are displayed within a Dblookupcombobox, only when I…
-
0
votes0
answers327
viewsHow to create a new database in ORACLE?
I installed oracle database, oracle client e sql Developer num windows 8.1 64 bits. With the installation of the oracle database, a database was created at localhost:1521 But now I would like to…
-
0
votes1
answer68
viewsSeparate data in table
I would like to make a table separated by "seasons". Example: Tabela estatisticas: Temporada 1: ID | JOGADOR | PTS | AST | 0 | Leonard | 12 | 7 | 1 | Pedro | 10 | 5 | Temporada 2: ID | JOGADOR | PTS…
-
0
votes3
answers193
viewsSelect only first place in the first half - SQL Server Code
I made this code for SQL Server to select how many times the driver "Asdovolante" came first in the first half of 2017. But it doesn’t work. What may be wrong? SELECT P.Data, Nm.Nome,…
-
0
votes2
answers2012
viewsCan I have a settings table without Primary key?
In a database, this table will be for storing information and will have only one line, and there may be updates and will initialize null and during the course of the program will be added. Is it…
-
0
votes0
answers102
viewsCalculated field
Good afternoon, I have a database made using the phpMyAdmin tool, but based on SQL. The database has a table that has a calculated field. The table has 6 records, but when I do the command for the…
-
0
votes1
answer40
viewsTotal registered in Database with Script
my php page uses the following files "1-config.php = connects to the database" "2-total.php = connects to the Form and shows the total record on the page" in the html of my main page I use <?php…
-
0
votes0
answers844
viewsRecover Data from Mysql
I uninstalled mysql, did not backup the database, but backed up the files: ibdata1, ib_logfile0 and ib_logfile1. The ibdata1 file has 17GB, in my.cnf innodb_file_per_table=0. How do I recover this…
-
0
votes1
answer272
viewsUnable to build Entity manager Factory
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence…
-
0
votes2
answers170
viewsAre there limits to the use of logical operators in the Mysql query?
Well, I wonder if there are limits on how many logical operators I can use in a Mysql query, for example: $sql = "SELECT * FROM usuarios WHERE nome = 'Fulano' OR email = '[email protected]' AND id…
-
0
votes1
answer47
viewsCodeigniter Database Size 3
Good afternoon, you guys! How do I know the number of rows in a database, using the Codeigniter 3 framework? I need to control the amount of data to be entered, so it does not exceed a certain…
-
0
votes1
answer24
viewsComparing a value of one table, with interval in another table
I am very lay in Access, but I need to use it to solve a problem. Assuming I have two tables (just to illustrate): Table A: CEP INICIO | CEP FINAL | CDD | CTC 20000-000 | 29999-999 | CDD Exemplo 1 |…
-
0
votes1
answer63
viewsFailure to enter data in the database by Radiogroup
I’m trying to save information in the bank through a Radiogroup, but instead of saving it in the column Status I hold the floor active he tries to find the column active. my form is like this: And…
-
0
votes2
answers1873
viewsCan Sqlite be considered a relational database?
According to Wikipedia, A relational database is a database that models the data in a way that the user perceives them as tables, or more formally relations. In my mind SQLite fits this definition…
-
0
votes1
answer46
viewsIf loop registration error
I have a registration form: <form action="Cadastro.php" method="post"> Nome de Usuário: <br> <input class="form-control" type="text" placeholder=" algo parecido com o seu nome"…
-
0
votes1
answer40
viewsMongodb finds no record of some names
I’m pulling some data from Mongodb with Codeigniter and came across something strange... Some records are found and others are not. Debugging the code I saw that the problem was the name he is…
-
0
votes1
answer30
viewsIndexing BD records
I recently circled a EXPLAIN ANALYZE in my database which is fairly large, about 800mil records in some tables, and I noticed that the indexing methods adopted were not the best. I always let the…
-
0
votes2
answers3407
viewsError: 'Executereader: Connection property has not been initialized. '
I need to make an access to a database where I put the data myself, the insertion part is working, but now I need to "take" the data again when I click on the button, only it does not matter the way…
-
0
votes2
answers1053
viewsHow to fill a list C#
I need an appeal similar to the one made below: email ListaEmail = new email(); … while … { email Email = new email(); Email.email1 = adoDR["email"].ToString(); Email.tipo =…
-
0
votes1
answer322
viewsMysql Time Count
I have a table where you count the time of client connections on freeradios, every time the customer enters or leaves the network he logs. I would like your help to know how long each user has…
-
0
votes1
answer45
viewsArchitecture Database
I have a question regarding the database. I have an X user who will be able to forward a message to N other user. What is the best way of this type of relationship? Should I create a table and…
-
0
votes1
answer6085
viewsRename entire Mysql Database
I wonder if it is possible to rename a whole Mysql database I have the Database Register with the people table I would like to rename registration to CAD_CRS It is possible?…
-
0
votes1
answer1201
viewsInsert data into codeigniter database
Say guys all right, I’m having the following doubt: I need to view and save data in my database but as I will show below I am using Joins to display, for example the name of an author using his…