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
answer2127
viewsHow to change product categories in Magento via Mysql?
I did the import of csvof the products from my store but they came with all changed categories. Is there any way to exchange categories via mysql or in some other faster way?…
-
0
votes1
answer1533
viewsHow do I enter into a ternary relationship?
I am creating this model however I do not know if it is correct. I have basic knowledge in database. How do I enter into a ternary relationship that happens in Supplier - Suppliers_has_product -…
-
0
votes1
answer3836
viewsPLS-00103 error when trying to compile a Package
I am trying to compile the package below and the error is being returned: Error(9,3): PLS-00103: Found the symbol "BEGIN" when one of the following symbols was expected: language CREATE OR REPLACE…
-
0
votes1
answer579
viewsHow to transform a query output into xml in Informix?
It is possible to take any output of a query directly from the bank and bring the result already formatted in XML text ? This using IBM Informix v11.50 database and natively in the database. Where…
-
0
votes1
answer1157
viewsShould I control the status of a system with a single table or several?
My question is somewhat conceptual and allows several interpretations. I am responsible for a system that uses status in several modules. Cargo status, order status, payment status, etc. For status…
-
0
votes1
answer213
viewsCan I add content tables in the same database as Users? ASP.Net Identity
I created an ASP.Net MVC 5, EF 6 project with individual accounts. The database is automatically generated with 5 tables: Aspnetroles Aspnetuserclaim Aspnetuserlogins Aspnetuserroles Aspnetusers Is…
-
0
votes1
answer81
viewsAPI 16+ Database Error
Well folks, I’m working on my application, and everything was perfectly fine... I had finished it with your help, but I found another problem. I was testing it on Android 2.3.3 because it was more…
-
0
votes1
answer3314
viewsHow to pass values to Procedure - PL/SQL parameters
I asked the management company of our system to change the code of some neighborhoods of the system, the same carried out such change, now I need to change the code of other neighborhoods that are…
-
0
votes1
answer938
viewsBank Access Attempt Log (Oracle 11G)
We have an Oracle 11G here in the company. Last week some joker tried to access for more than 10 times with incorrect user or passwords. I searched and I’m searching for some way to save access logs…
-
0
votes1
answer782
viewsOauth vs Conventional login system authentication. Which to use?
Imagine the following scenario: You are setting up a project where anyone can register with basic data (name, photo, age) to use your product. And as it is on the internet there is no way to predict…
-
0
votes1
answer135
viewsEdit similar fields in codeigniter
Imagine the following situation: Registered in a database several phones of a single establishment (local_1, +55 xx xxxx-xxxX; local_1, +55 xx xxxx-xxxY; ...); The problem: Allow the user to edit…
-
0
votes1
answer108
viewsWork to relate tables
Personal talk. I am developing a portal aimed at music, the idea and give all necessary information to the visitor about his favorite artist/ band: as Photo of the band, Description , Website,…
-
0
votes2
answers197
viewsError making an insert in the database
I am trying to save some data in the database and am getting this error: The INSERT statement conflicted with the FOREIGN KEY Constraint "Fk_dbo.Occurrences_dbo.Alunoes_alunoid". The Conflict…
-
0
votes2
answers1215
viewsIs it possible to assign Objectid() to subcollections in Mongodb?
Imagine the following Gospel: { _id:ObjectId("123456..."), user:"João", artigos:[ { id: new ObjectId(), titulo:"Lorem ispsum.", texto:"Lorem ipsum dolor sit amet..." } ] } In short: A user may have…
-
0
votes1
answer664
viewsHow to know if a file has been viewed
I’m making a system in php where the counter sends a file to the client (using database). My question is the following, how to do when the client accesses this file, is sent to the database the time…
-
0
votes2
answers60
viewsRescue BD Data Only Filled
I’m having a problem when I have to show the database data and they’re empty because the name pops up and the blank space. Nome: Pedro Nome: Ricardo Nome: Nome: Nome: and wanted to know if it was…
-
0
votes3
answers2325
viewsOrder By - Leave specific record for first
Store_Name | Sales | Date America | 1500 | 05-Jan-1999 Boston | 700 | 08-Jan-1999 Canada | 300 | 08-Jan-1999 Dinamarca | 250 | 07-Jan-1999 I have this table, I’d like to sort in a way where Boston…
-
0
votes2
answers1524
viewsHow to display two different database tables in php
Hello personal is the following, I have 2 separate tables, and can not do Inner Join, because they have no data in common, I wonder if it is possible to display these two tables in a single page.…
-
0
votes2
answers2020
viewsRAD Studio XE6 does not connect to any database!
Program used: RAD Studio XE6 (32bits). Problem: When creating a new Desktop or Mobile project, when trying to configure the connection to any database, whether by Firedac or dbExpress, the following…
-
0
votes1
answer502
viewsError in Function connection class code
I’m in trouble, look at the code I made: <?php class banco { public function __construct() { $banco_hostremoto = "127.0.0.1"; $banco_hostname = "localhost"; $banco_usuario="root";…
-
0
votes2
answers460
viewsExtract Firebird Database with Predefined Layout
I need to extract some information from the database, with a predefined layout and launch into a file. TXT Example: 1 to 10 digit size code; name size from 1 to 20 digits; date sale size of…
-
0
votes1
answer1154
viewsOpen gallery, select and save address in database - Android
I was wondering how I can open the gallery in my android app at runtime, select an image and copy that image to a folder of my application in SD card and save the image path in the database, someone…
-
0
votes1
answer254
viewssum values and boxes after the comma
Good morning guys, I’m having a little problem here and I’d like a little help from you, I have a select here that brings the workload of one student per subject, for each student it repeats the 2x…
-
0
votes1
answer1185
viewsInserting data into the BD with codeigniter in different tables in the same controller
I have two tables in the database, a form with Tabela1 fields and table2! the insertion of the Table 1 fields is occurring normally, however, the insertion of the table2 is not taking place! Simply…
-
0
votes2
answers89
viewsHow to order Contacts by name?
I have the following code and would like to make an ORDER BY name: try { String clsSimPhonename = null; String clsSimphoneNo = null; Uri simUri = Uri.parse("content://icc/adn"); Cursor cursorSim =…
-
0
votes1
answer113
viewsHow do you request Core Data to get only one attribute?
I just need to get an attribute from a single row of the table: name | id | idade | aprov|repro| sala | _______|______|________|______|_____|______| John | 32 | 15 | A | | 155 | Following the table…
-
0
votes1
answer193
viewsValues that are calculated, if you store the value with the calculations in the database?
I am developing a system where a product undergoes 3 changes before reaching its final value: Individual Discount, Selling Bonus and General Discount I want to know if, I should store only the…
-
0
votes0
answers53
viewsInsert data into the DB and then change tab
How can I skip to tab after entering data into my database? private void botaoAvancarTab1ActionPerformed(java.awt.event.ActionEvent evt) { String inserirArtigo = ""; String nome = txtNome.getText();…
-
0
votes0
answers80
viewsPointer error in a table fill method
Apparently it is to be right, but when I run the following errors: Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at bibl.PesquisaSimpl.preencheTabela(PesquisaSimpl.java:188)…
-
0
votes1
answer489
viewsDelete a record after making a query?
Exists as after a query delete the returned result from a bank? I have a message table (from,to,message) each time I refer I should delete the read message(s).
-
0
votes3
answers1715
viewsCreate a Trigger that runs whenever a product is deleted
How to create a Trigger that is executed whenever a product is deleted, performing the delete action in all batches related to the deleted product. Here’s my SQL code: create database provafinal;…
-
0
votes1
answer955
viewsSynchronize databases via Webservice C# Asp
I have databases on the server and on the client and would like the changes made in one to be sent to the other via a Webservice. For example, a new row is added to a table on the server, then this…
-
0
votes0
answers578
viewsCreating a PHP network panel
I am with the following doubt I have an oracle database with all the names and ip of the users. I would like to use this database in this code instead of using this array? <!-- painel.php -->…
-
0
votes1
answer149
viewsWhy am I not able to do the INSERT in the database?
<?php class Connection { private $nome; private $data_nascimento; private $genero; private $rg; private $cpf; private $email; private $telefone_fixo; private $telefone_celular; private $cidade;…
-
0
votes1
answer1057
viewsProblem saving result of an SQL query to a PHP variable
I have a SELECT to return the value of a table field funcionarionew, my idea is to save the result of SELECT into a variable and then insert the value of that variable into another table…
-
0
votes1
answer1385
viewsError: table name specified more than Once
I created a column included in the app table, it works to record the purchase date of the app and I will have to update the old records with the user creation date. I made a query to solve the…
-
0
votes0
answers125
viewsRemove() from Entity Framework 6 only works when recreating the connection
I am creating an EF6 application and I came across a problem. I am using the concept of repository and when I run a delete (context.remove(obj)) and after that I reload the list and datagrid, I…
-
0
votes1
answer10171
viewsOpen GDB file
I’m developing a system where I need to use the database from another system, a sales system. This sales system is very old and the file where the database is kept has the format .GDB. Products,…
databaseasked 9 years, 8 months ago user21494 -
0
votes1
answer178
viewsTake the values of a table and use to create a new database
Well I have the following problem: I’m switching from server to agency, and I came across the following problem: it had only 1 database and within this database there were several tables with client…
-
0
votes1
answer110
viewsUpdate database by SQL PHP
Staff I am having difficulty updating my database to decrease the weight by 1 kg. Any help I appreciate. The code is as follows: <?php class Aluno{ public $nome; public $endereco; public $peso;…
-
0
votes3
answers137
viewsProblems with WHERE IN (many records)
I need to assemble a query to search for records in table A, with table B record filter. Something like: SELECT * FROM tabelaA tblA WHERE tblA.coluna IN (1,2,3,...) The values contained in the "IN"…
-
0
votes0
answers697
viewsTable with self relationship
Good morning. I have a table that uses auto-relationship, it turns out that not all names entered have parent, but I can not create a name with null parent, there is not be the first that was…
-
0
votes3
answers1649
viewsInserting column in Oracle table with conditional
I need to create a column in an existing table but need to do with a checking condition if this column already exists in the bank I did so but it throws an error: DECLARE col_count integer; BEGIN…
-
0
votes0
answers324
viewsIs there any way to encrypt the Firebird Embedded database?
I intend to use the Embedded version of Firebird on my application server. Is there any way to encrypt and use this database as in Sqlite?
-
0
votes1
answer1869
views -
0
votes0
answers552
viewsDoubt in the database update through a modal
I have a form through a modal, where it performs updates in the Mysql database. However, there are times when clicking on "Forward" the action is not executed, and at other times the action works…
-
0
votes1
answer125
viewsdelete record from an sql table
Good people I want to delete a record from a table but for that I need to get information from other tables and because of that I am not able to delete. I basically needed an SQL command that…
-
0
votes1
answer389
viewsDelete only one record in the database
While executing the code below, more than one record is deleted from the database. I cannot find the problem. Code to delete excluir_client.php <?php require 'repositorio_clientes.php'; $clientes…
-
0
votes1
answer102
viewsstore php log id
Good people, my goal is to store the registration id that was entered in the database $sql = "insert into pacientes (Nome, idade, dataNascimento, estadoCivil, nacionalidade, naturalidade, morada,…
-
0
votes3
answers88
viewsPHP and database
Great, I’m working on a website and I need to store a file inserted/uploaded by the user in a database. What type of data should I assign to the field?