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
-
1
votes2
answers286
viewsCan you get the value of an autoincrement column before it is saved in the database?
I have three tables: preco, estabelecimento and precoXestabelecimento. The id of price is autoincrement and there is a relationship N:N between the first two tables, which is represented by the…
-
1
votes1
answer91
viewsList records without reference in another table
I have three tables: -customers -plans -services On the table services have servico_A, servico_B and servico_C that are related in the table plans. I need to list all customers who do not have a…
-
1
votes2
answers718
views -
1
votes1
answer214
viewsDifferent Model type objects mapped from a single table
It is possible to map from a single table of the database different objects of type Model with Activerecord in a Ruby on Rails project? Suppose I have in the database a table with the name customers…
-
1
votes1
answer1056
viewsIs it possible to access multiple databases in the same project of Laravel 5?
The scenario is this: I have a website that can be accessed by 5 different countries -> br.meusite.com, us.meusite.com, fr.meusite.com, ... . All Urls direct to the same folder within the server…
-
1
votes2
answers93
viewsGroup views in SQL Oracle
I’m having a little logical reasoning block. I have a table (Tabela1) organized this way, but I would need to return the query as the table2 below. Someone can help me?…
-
1
votes2
answers81
viewsIs it possible to make Postgresql database data visible or not, without erasing it?
I have an application where in addition to registering and consulting clients, it allows to issue reports with customer information, the problem is that many of these customers already registered do…
-
1
votes1
answer54
viewsDoubt with "pivot" ORACLE
I would like to know how to put the fields CODIGO_PROCESSO, NOME_PRODUTO_PROCESSO and APROVADO_USO in the main select to show in my query SELECT CODIGO_PROCESSO, MAX (DECODE (tipo_arquivo, 'BT',…
-
1
votes1
answer235
viewsData persistence using Event sourcing
Recently I heard about Event Soucring in a video by Greg Young and I found an idea that seems to be very useful in various systems where having a data history is important. What I understood is that…
-
1
votes0
answers68
viewshow do I develop a registration, listing and consultation system for vehicles and automakers? Obs:the listing is by name, by year, price range and by engine
def main(): titulo = '***** Veiculos.BD ***** \n ' menu = titulo + '1 - Novo Veiculo \n 2 - Listar veiculos'\ ' \n 3 - Remover \n 4 - editar \n 0 - Sair \n Opcao >> ' veiculos = [] while True:…
-
1
votes1
answer365
viewsHow to read properties file to configure JPA?
I have a file . properties to configure my project’s database. However, I cannot read the file. Someone gives a force? Entitymanagerproducer @ApplicationScoped public class EntityManagerProducer {…
-
1
votes1
answer186
viewsSelect Hibernate criteria with mapped entity
has how I make a select, using the criteria and bring an uncharted entity, would be several joins, and sometimes bring certain fields and others not.
-
1
votes1
answer588
viewsIs it possible to leave connectionString dynamically?
I’ve read something and I know it’s possible to leave one connectionString dynamically in an ASP.NET MVC application. However, it is possible to create n connections where each authenticated user in…
-
1
votes1
answer380
viewsAuthenticate in a database and change information in others
So, I need to create an application with Laravel 5 where it is possible for different users to be authenticated in a specific database where the system is. After logging in, each user can change…
-
1
votes2
answers99
viewsWhat is the correct way to choose column types?
I always see tables as follows. Ex: CREATE TABLE posts ( id int(11) NOT NULL, titulo varchar(255) NOT NULL, autor varchar(255) NOT NULL, conteudo text NOT NULL, data varchar(11) NULL, )…
-
1
votes0
answers192
viewsHow to model a system of friends with Mongodb?
I’m creating a small social network and I need to create the friendships part. I have two ideas: A Collection Friendships containing the fields sender, destnatary and answer and make a populate with…
-
1
votes1
answer44
viewsSELECT user by Date
I have a Select mysql searching my clients by taking the name, email by date of day... I need to get the results that are from today (WHERE data_cad='$dataHoje') and I need to select one by one to…
-
1
votes1
answer49
viewsError in php connection file for mysql database
Mistakes: Warning: mysqli_stmt_bind_param() expects Parameter 1 to be mysqli_stmt, Boolean Given in /home/a9630388/public_html/Register.php on line 7 Free Web Hosting PHP Error Message Warning:…
-
1
votes2
answers167
viewsHow to use Database Diagrams in Visual Studio 2015
I’m doing the exercises in the book: "Use the C#Head", and one of the exercises was asked to create a Database Diagrams. But you don’t have this option in Microsoft Visual Studio 2015. Book page: So…
-
1
votes1
answer113
viewsMultiple sharing users when installing SQL Server
I recently installed the SQL Server Express 2016 on my machine with Windows 10. After a while I realized that on the menu "Share with" windows appeared 13 new entries in format SQLEXPRESSNN, where…
-
1
votes0
answers237
viewsA plugin by the name "getServiceLocator" was not found in the plugin manager Zend Mvc Controller Pluginmanager
I recently started learning Zend Framework2 from Angularjs through a course from the School of Net. Considering the year of the course, which if I’m not mistaken is 2013, some things have changed in…
-
1
votes1
answer107
viewsRelate MYSQL Table
I am developing a system for a Church. I have a table of registration of people, but I need to relate this table to itself. I want to list in this same table everyone who has some kinship and…
-
1
votes1
answer1034
viewsInvalid Mysql PHP PDO Data Source
I’m having problems connecting PDO to mysql database. Database_connection.php: <?php class Database_connection { private $db_host = "local"; private $db_name = "root"; private $db_user = "user";…
-
1
votes1
answer392
viewshow to load data from a page according to the clicked ID?
What I want is very simple, I want to click on the name of the person, load another page with the complete data of the person according to the data previously clicked and there I can edit the data…
-
1
votes1
answer465
viewsLaravel 5.2 - Relationship Many To Many between records of the same table
The tables: The table users, records users who may have N functions that are stored in the table funcoes (student, responsible, teacher, etc). The table funcao_user is pivot that makes the…
database laravel laravel-eloquent relationship laravel-5.2asked 8 years, 1 month ago Julio Alves 83 -
1
votes2
answers36
viewsSearch only data from two tables with different id’s
Good, I have 2 tables: Cars: id; model; Comb; price; Carros_img: id; id_fk; (Foreign key of Cars) img; I do this research: SELECT DISTINCT carros.id, carros.modelo, carros_img.img, carros_desc.comb,…
-
1
votes1
answer1190
viewsHow do I sync an offline database to an online one?
I have two identical databases, one offline and one online. In every field of a table I have a column called online with values 0 (did not send the data) or 1 (already sent the data). Usually I…
-
1
votes2
answers73
viewsBug change position of banners site Laravel
I’m developing a website where it has a banner modal and I want to define a field in the database of type "order", where I can define which banner appears in first, second, third ... on my admin…
php database laravel laravel-5 laravel-eloquentasked 8 years, 1 month ago Danilo Tiago Thai Santos 409 -
1
votes1
answer244
viewsInsertion of dates in Postgresql
I would like to know how to configure the Postgre to accept date entries as follows: "12122016". I know that with the same "spelling" is possible with YMD more I would like to know how to set up to…
-
1
votes0
answers83
viewsSave IP server data
Good morning people when trying to connect to a server I set up my firewall and configured the files pg.conf and pg_hb.conf to allow remote connections but presents this error could help me ? it…
-
1
votes1
answer300
viewsReporting - Consistency of data when prices are changed
I have the following database: Requirements: the prices of the lunch boxes and the address of the customers can be amended as necessary. every week I need to generate a report from that database,…
-
1
votes1
answer1431
viewsHow to stratify/divide a data.frame into categories of a variable in R?
I am running a linear regression model on R and would like to perform stratified analysis according to categories of a variável X with 4 categories (X1, X2, X3 and X4). I thought I’d stratify the…
-
1
votes0
answers136
viewsSave multiple photos in SQL Database in same ID
I’m having trouble saving multiple photos in a single id this is the Cs of the page that makes the register protected void btnSalvarImovel_Click(object sender, EventArgs e) { try { var cmd = new…
-
1
votes0
answers85
viewsEvolution of the code-controlled data model
In a scenario where the application is deployed for production through a pipe line run by an CI server, where the server performs the following tasks: Installs front end and back end dependencies.…
database relational-model automation continuous-integrationasked 8 years ago Dimi Antoni Vargas 316 -
1
votes2
answers701
viewsIn Netbeans it works, not in Jar
I know you have some similar topics, but none of them answer my question. I created a program to insert information into the database and it works perfectly when I have netbeans compile. I made the…
-
1
votes2
answers160
viewstool or technology to assist in controlling database data
I have a web application, that constantly the database receives data, the application is all tied to the database. if a change is made can compromise the whole system, I wish I could return a point…
-
1
votes1
answer621
viewsHow to compare the structure of two tables and update the other?
The question is the same as the title: How to compare the structure of two tables and update the other? I have an online database, which I intend to update its structure. I also have some customers…
-
1
votes1
answer92
viewsInsert to the C#Dynamic Database?
I’m making a insert and use a model with the Getters and Setters, when I do the insert in the values I receive to model as a parameter and use as follows sql = "INSERT INTO " + Table + "(" + campos…
-
1
votes1
answer1041
views -
1
votes2
answers60
viewsSave form attribute without name defined
I have a problem with a php script. The name attribute of a page receives a value that is generated by an array. What I need to do is basically generate a table in which each row has a button that…
-
1
votes3
answers14296
viewsExport SQL Server query to CSV file
I need to somehow export the result of my SQL query to a CSV file. However, it has to be directly via SQL or VBS. Or else, all database table data can be exported to CSV.
-
1
votes2
answers960
viewsSearch inside the input and open another page
Hello, I’m creating a project in my computer course. I would like to know the best way to do a database search within an input, and open another search page. Note: I am using php, I used input and…
-
1
votes2
answers158
viewsMysql update filtering by due date with tolerance of x Days
I need to update only records that are expired and add a tolerance of x days Example Tolerance of 5 days Today is = 11/10/2016 id= 1 maturity = 10/10/2016 // only update if today was day 15 id= 2…
-
1
votes0
answers126
viewsConnect Sql Server Express 2014 with Visual Studio 2015
I can’t make the server name appear in Visual Studio, I have the firewall disabled and I have checked that the server is active, please help me Thank you in advance.…
-
1
votes2
answers904
viewsGenerate empty row (null) in sql server
I don’t have much knowledge of sql, but I need to do the following procedure: User gives a number. Sql generates the amount entered by the blank/null record user. After generated the blank records,…
-
1
votes1
answer225
viewsDoubt with relation of tables Database
Good afternoon, I am developing a system for my learning and I came across a situation where I was in doubt. I have the table in the bank where the questions are recorded. Table question :…
-
1
votes0
answers38
viewsProblems with strings copied from a spreadsheet
I have a system that uses the Codeigniter framework, this system has some fields that the user uses to register things... The user copies some phrases that are standard of a spreadsheet of Libre…
-
1
votes2
answers689
viewsDate value 0000-00-00 cannot be used in java Date
First of all yes, I’ve already added ?zeroDateTimeBehavior=convertToNullin the connection URL the problem is that in the query the reset date is not null and always release the following…
-
1
votes1
answer24
viewsUploading multiple images in the same db column starts with comma
The db record is starting with a comma. The code begins with: $imagens_nome =""; foreach($_FILES as $file).... Upload and create thumbnail... Generates a new name : $Novonome and then before…
-
1
votes1
answer96
viewsHow to delimit a phone field (Oracle Database)
Good morning, I am in need of a help to delimit the phone field in my database, being more specific, if today someone type a phone number with 4 digits (for example) that phone will be saved, I need…