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
votes1
answer131
viewsIndexeddb does not connect on Android 4.2
I am working on the Intelxdk IDE, and I use Indexeddb to persist some files. By emulating the project in the IDE, everything works perfect, it makes the connection, it brings all the data,…
-
0
votes0
answers194
viewsHow to loop within a variable in Javascript?
I have a page index.php. In it has a loop which collects row by row from a mysql database table and inserts into variables that are sent to the file dashboard.js where the code is below. var…
-
0
votes4
answers1278
viewsDifficulty with MSSQL and PHP on Centos 6 server
I cannot run a PHP system on the server (Centos 6). When I try to connect to a MSSQL database the following error appears: Call to undefined function mssql_connect() My localhost works normally. The…
-
0
votes0
answers680
viewsFirebird C# create a single connection to the database
I need to create in my application only a connection using the fbconnection that will be shared across the application. I performed this procedure as follows. I created a static class that provides…
-
0
votes1
answer186
viewsUpdate does not update
The app works like this: An SMS is received, so the app checks if the number that sent this SMS is registered, if the app checks the first twenty characters of the message, which I call text…
-
0
votes0
answers155
viewsOptions of multimedia databases
I know there is blob type in the most common databases on the market to save files, but there is some other database developed specifically to work with multimedia files? ps: I have no purpose for a…
-
0
votes1
answer194
viewsSet custom database settings in Laravel
My situation is as follows, I have several settings with the database set in the file databade.php, so far so good. But there are some connections that need data 'variables', such as the name of the…
-
0
votes2
answers52
viewsProblem adding photo to database, what to do?
I choose a photo through this part of the code on a php page: <label for="foto">Foto:</label> <input type="file" name="foto"><br><br> And then I need to register her in…
-
0
votes0
answers636
viewsDatabase Modeling - Self Relationship
My Case I have a table empresa, this table has fields known as cnpj, razão social and login. This same company may register another in its catalogue of companies. The company registered by it will…
-
0
votes1
answer280
viewsDoubt database / batch control system
I’m working on a project where I came across a problem where I don’t know what would be the most efficient way to do it. My project has a register of products in which I want to control by lot,…
-
0
votes1
answer497
viewsDatabase structure for poll system
I have a project to develop an online polling system. I am concerned about how I will get the answers to the questions to show in a graph. Each graph is each question to be analyzed. Let’s see, if I…
-
0
votes0
answers43
viewsCan I use the result of the Case clause as a field in Select?
This question refers to this: How to return day of week and time formatted sql server 2008? I’m trying to fix it: SELECT CASE DATEPART(DW, GETDATE()) WHEN 1 THEN 'DOMINGO' WHEN 2 THEN 'SEGUNDA' WHEN…
-
0
votes1
answer275
viewsCompare all records in table "A" with each record in table "B"
I am a programmer and rarely use database, I came across an unusual situation of converting multiple files . DBF and save everything in the bank on their respective tables, however some files exceed…
-
0
votes0
answers682
viewsAndroid Studio app with Sqlite Java database
I’m developing an app that takes photos and saves it along with a text written by the user himself in the SQL database. For now I can make him take the photo and open the text box for the user to…
-
0
votes1
answer170
viewsSqlupdate does not change data in the database
Note: Several people could not solve this question and marked my question as erroneously duplicated because of an answer in a similar question but the answer does not help me at all. I am developing…
-
0
votes1
answer168
viewsJPQL - SQL query
good night. I have a bean, which has an init() method. One of the objectives of this init is to bring the cycle that was opened according to the course of that user, that is, If there is no cycle or…
-
0
votes1
answer1963
viewsChange data from a column in the table
I need to change 1200 records only from one column in the table, generated the data in the generatedata, the rest of the columns must remain with the data, someone knows a quick way to this process?…
-
0
votes0
answers55
viewsProblems with using FK, SQLITE3 and C
I am having trouble recording records in my log table that has a client table FK. The error is in the insert_log function() SQL to create tables sql_create_client = "CREATE TABLE cliente (id INTEGER…
-
0
votes1
answer108
viewsErrors when inserting images in mysql
Hello, I’d like to insert images into the database for a personal project. The image is sent to the bank yes, but not without showing 3 errors, follow the code and errors : <?php $servidor =…
-
0
votes1
answer1038
viewsSqlite android query() / like with accents and without
How to make a query in Sqlite for Android that searches both accented and not accented words? For example: String[]ARGUMENTOS = {"%"+argumento+"%"} query(TABELA_CIDADES, COLUNA_NOME, NOME + " like…
-
0
votes0
answers101
viewsbring data from the database according to other data registered
I have a code that brings the database data and generates a table. This data is coming all that are registered, but I need only data with the same user status come. For example: I have a user from…
-
0
votes0
answers51
viewsBring user information to the model
I have a code that lists several reports. These reports are saved in the database and to call them I use the Model in the Codeigniter. Inside the model, I have one where and to make it work…
-
0
votes1
answer58
viewsSQL Server Transaction Replication - Primary Key
I have an environment with 2 branches, each branch has to have an application server with an SQL SERVER installed, I have configured the transaction Replication which is working perfectly, but if 2…
-
0
votes1
answer219
viewsSort by ENUM Mysql value
I have a question and since I did not find anything on the internet I decided to ask you, well, I have a Mysql table and this table contains an ENUM field that can be 'yes' or 'no', I wonder if it…
-
0
votes1
answer1470
viewsHow is a specialization implemented in a bank?
In my ER model and diagram I created a specialization for an entity called clients, where it relates to the physical and legal entities derived from this specialization. I simply create the…
-
0
votes1
answer58
viewsGroup function does not work
I have two tables. Table: Pedido Columns: IDPEDIDO, CLIENTE, DT_PEDIDO, FORMA_PGMT, CLIENTE_ID. Table: Itens_Pedido Columns: PEDIDO_ID, QT_MERCADORIAS, MERCADORIA, MERCADORIA_ID. I need to create a…
-
0
votes1
answer6172
views"No such file or directory " error but the file is saved in the database
I have the following problem: when I submit a form containing photographs the error described in the title appears. If you only upload a photo, it will no longer appear. But even if you make a…
-
0
votes1
answer187
viewsAbout Trigger no postgres
Good guys, my problem is this, I want to make a table partitioning in postgres because a table has zillions of records and searching for it takes a lot (this table tends to grow considerably in the…
-
0
votes2
answers4255
viewsTables are not shown in Oracle SQL Developer
I have several connections configured on TNSNAMES.ORA, and for some I cannot see any table if I expand the folder. The user I am connecting has access, because I do the queries and insertions…
-
0
votes1
answer643
viewsFilling a Listbox with Paradox(Delphi) Database
Good afternoon, my friends. I’m having trouble filling a listbox with information from a Database table in Paradox, Data Source is the file "Gap03dm.Sourcechaves" and Datafield is "Field". How to…
-
0
votes1
answer87
viewsHiding Delphi null field mask
I have a Dbtext field with phone information, I formatted the field that way "! 99999-9999;1;_", only when a null field appears, it ends up displaying the hyphen that separates the numbers, it has…
-
0
votes2
answers555
viewsController pulling database data from wrong place
I have the application properly configured and running normally. But one detail is jamming. This is my file . env: APP_ENV=local APP_DEBUG=true APP_KEY=9FaEj6iJCBur1favtWQ88b8m1anbGbzP…
-
0
votes1
answer1903
viewspgsql connection problems in Laravel 5.1
I am trying to connect to the pgsql database by Laravel 5.1 but an error is appearing: Pdoexception in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using…
-
0
votes0
answers232
viewsMysql Query Same Column Different Parameters
Opa, simple thing, I have a test table, orgao and state tables teste = 'teste_estado_id_1' 'teste_estado_id_2' 'orgao_id' orgao = 'orgao_id' estado = 'estado_id' In a query you need to relate the…
-
0
votes3
answers4197
viewsSelect from two tables without repeating data
I have two tables, one for users and one for photos where each line contains the user id of the respective photo. I want to select the user data and grab the photos by the user id of the photos…
-
0
votes0
answers104
viewsFirebird Database with problems
I have a new Firebird Database, deployed less than 60 days, until then little used, in one day its size was 40 Megas, in less than 6 hours happens users complaint about slowness in the system, when…
-
0
votes2
answers80
viewsWhere to create a database without privileges
I created, at work, a "program" in Access because I need a database, and have a graphical environment, everything was running on until the company "remembered" to delete Access from the available…
-
0
votes1
answer140
viewsMap image and save array to database
I have an image of the human dental arch. I want to display it and when clicked on a given tooth, the value was filling in an input text field. Example: [13,12,11] The image I’m going to use is…
-
0
votes1
answer225
viewsHow to increment the varchar() code field automatically in Mysql?
I need to do a stock control, where the code of the products should be varchar, because the code will be formed by the abbreviated name of the product category followed by a sequential number, so I…
-
0
votes1
answer1610
viewsDatabase for E-commerce site
Good morning before, some doubts arose when I was developing the database of my online sales site (only for lesson context...). It is the following, I have the products table, then I have the cart,…
-
0
votes1
answer769
viewsHow to change the Auth database of Laravel 4.2?
My project has two databases: one for the user account and another for the project domain. My need is to define the database that the Auth uses for authentication, because in the default…
-
0
votes1
answer2872
viewshow to create a php stopwatch with start and finish button?
preferably in php, but it can also be in javascript and please pass the values of time to a variable in php, because it will have an input to register the time taking to another page in php to…
-
0
votes0
answers41
viewsHow to know when the Sqlite query ended?
In my app I have a synchronization method, this method downloads several entries from my webservice and inserts them into the local Sqlite database through a for loop. I need to know when the Sqlite…
-
0
votes2
answers47
viewsCount script - Sqlserver
I own the table Telefone , that records the phones they called. I need to make a script that shows the number of phones that called. If a phone calls more than once, it doesn’t count. I need to do…
-
0
votes1
answer26
viewsFilter and count related model data
Enterprise hasMany Setorempresa Setorempresa belongsTo Enterprise Setorempresa hasMany Functionary Functionary belongsTo Setorempresa With this data in hand, how do I count how many id_status = 1…
-
0
votes1
answer366
viewsFill a Select Multiple and Update Table
I have a <select multiple> which is filled with information from a table exams, the user selects the exams he wants for a certain function and sends to register in the table exams, okay. My…
-
0
votes1
answer82
viewsCreate ODBC Informix data source
Problem: I need to register a INFORMIX data source and I’m not getting it. I enter the parameters, but always error occurs. What should I do?…
-
0
votes0
answers370
viewsRegister multiple elements with multiple images associated in a single BD in php
I am doing a function to register products on an E-commerce platform. The function is as follows: the user registers the base product after registering its variations (color and size, for example).…
-
0
votes1
answer97
viewsI cannot save a query in the Database. Shows error Unfortunately
I’m almost two weeks with this problem in my android code, I already searched in some forums and nothing, so I’m kind of desperate looking for help. I’m new dealing with android, if anyone can help…
-
0
votes1
answer358
viewsHow to set the boot value of a PRIMARY KEY field set to IDENTITY in SQL Server?
In Mysql when creating a table with an AUTO_INCREMENT field being PRIMARY KEY it is possible to define what will be the initialization value of the first record of the same, as follows the script…