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
answer44
viewsDatabase - table list
Personal as I can list all the BD table and put in a table, list or in any one corner of the page?
-
0
votes0
answers65
viewsSQL error in your SQL syntax
I am importing an sql with the following code: CREATE TABLE blog ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(250) NOT NULL, body TEXT NOT NULL, url VARCHAR(250) NOT NULL); But is returning…
-
0
votes0
answers683
viewsHow to record and display images using Postgresql and Laravel 5.1
I have the following code in my Controller to save the image in the database, not any error so I think it works right. $data = Input::file('assinatura'); $escaped = bin2hex($data);…
-
0
votes0
answers162
views -
0
votes2
answers75
viewsView images that are in another table
Hello, I have the two tables below: Table IMAGES id_imagens | diretorio_imagem | post_id 1 imagem1.jpg 1 2 imagem2.jpg 1 3 imagem3.jpg 1 4 imagem4.jpg 1 5 imagem5.jpg 2 6 imagem6.jpg 2 7 imagem7.jpg…
-
0
votes1
answer129
viewsColumn type for support table
I have a client table and would like to create a support table to avoid creating many columns (address, phone, phone1, email, Email1, Email2, car plate, mother’s name, etc.). The support table…
-
0
votes2
answers323
views -
0
votes1
answer49
viewsAction update widget dynamicform not saved in Yii 2.0 database
Hello Folks I can a registration form, which has a main table po, and a secondary table po_item to save multiple records, but in the update action the form does not back the records of the database…
-
0
votes1
answer1368
viewsHow to find Null values without specifying attribute (Mariadb)
I would like to do a search to find NULL values across the table without having to determine which of the attributes might contain NULL. NOTE: By ALL table I mean that somewhere in it you have null,…
-
0
votes1
answer37
viewsQuery with Join returning empty
Please help me check my query because it is giving an error that I am not able to identify. If I do the simple consultation: SELECT * FROM respostas WHERE resp_usuario='8' AND resp_questionario='6'…
-
0
votes0
answers67
viewsHow to receive data from a Codeigniter 3 store
Create a previous store in mysql. Using Codeigniter 3 already configured to use the mysqli driver, I tried to receive the data returned by SP but was not successful. SP: CREATE…
-
0
votes1
answer75
viewsBD Access, Data field
In an Access BD with a "Data" field, when entering data in this field, is it possible to do something so that dates passed 3 days ago are rejected? If possible, please teach me! In fact, I only…
-
0
votes1
answer1994
viewsHow to Get Data from a Mysql Database from id
Good people have this voting system where it saves in the database the votes . Only that it pulls all the data at once using the code below, the file will return ALL registered names. But I want to…
-
0
votes1
answer1199
viewsUse FULL JOIN in Mysql
I needed to make a query that I return in a row the data of a candidate plus the courses to which I applied, and this data is in a relational table 'tblcandidatoCurso'. After some research I tried…
-
0
votes2
answers134
viewsSelect in table records with Mxn relation
Hello, I have in my bank a table tb_usuario (id INT, name VARCHAR, flag_active INT) and a table tb_regional(id INT, name VARCHAR,login VARCHAR, password VARCHAR). From the relationship between the…
-
0
votes2
answers1453
viewsIndex views in Mysql
I have a view in my Mysql database, I would like to know if it is possible to index the fields that are contained in it, because I have a group by on it that is consuming much, and a index would…
-
0
votes1
answer476
viewsReturn a CURSOR from a Sqlserver using dynamic sql (sp_executesql)
In the oracle I can do as follows : OPEN MY_CURSOR FOR 'SELECT * FROM MY_TABLE' How to get this result in Sqlsever? I want to return a cursor by mounting a dynamic sql in the Procedure. I’m…
-
0
votes2
answers240
viewsINSERT CONCATENATE PHP MYSQL
I am wanting that when entering a register in mysql , according to the id already have something predefined example I will insert a post with the category id = 2 , then the name of my post will be…
-
0
votes0
answers296
viewsHow to mark time in the database of a javascript timer
I have javascript code that calculates the time (seconds, minutes, hours) I have an input of type Submit to each click wanted to register in the database the time, and that automatically came back…
-
0
votes1
answer112
viewsHow to Save Data to Generate a PDF?
There is a part of the system where the user will fill a lot of information just choosing between options selects, those selects are fed information I have registered in my database. When I am…
-
0
votes2
answers120
viewstextbox saving in bank even if empty
Validation and message: if (txtFone.Text.Trim() == string.Empty) { MessageBox.Show("O campo Telefone é obrigatório!"); txtFone.Focus(); return false; } Save button code: if (this.Valida()) {…
-
0
votes2
answers457
views -
0
votes1
answer406
viewsQuery with the following logic
Hello friends of the community. I need to fill a chart but I can’t assemble the query to receive the attributes, could someone help me? The query I need to do is the following. select client.name,…
-
0
votes1
answer73
viewsLaravel - Route "insecure"
I am doing a function to evaluate a transaction between a client (company) and his client (end consumer). Then an email/sms is sent to the final consumer with a link for him to evaluate the…
-
0
votes1
answer856
viewsExport and Import Mysql Table
I have a Wordpress plugin, which can be used on multiple blogs with the same configuration. I have two tables in it: wp_tabela_um and wp_tabela_2 How can I create a button to export these tables and…
-
0
votes2
answers1232
viewsHow to change persistence.xml file settings through an external file?
I wanted to know how to change the configuration of the persistence.xml file through an external file. I am using JSF + JPA. I want to do this so as not to leave this setting stuck in the source…
-
0
votes0
answers370
viewsCRUD Mysql , I need a button that fills inputs
Good morning, I have a question about how to make the above inputs receive data from my database, for example: let’s assume that I will change something, but I just want to change a value the…
-
0
votes3
answers81
viewsWorking with date and deadline checks
I’m a logical problem in my application. Guys, here’s the thing, in the project module of my system there is a deadline for delivery of the project. I need to know the following. If today’s day is 1…
-
0
votes0
answers160
views -
0
votes1
answer62
viewsHow do I connect php to the database of this registry?
The registration code is this: <form class="register-form"> <input type="text" placeholder="nome"/> <input type="password" placeholder="senha"/> <input type="text"…
-
0
votes0
answers49
viewsHiding database information in php
Code: foreach ($controller->ListaDados($objCheck) as $objCheck) { ?> <table bordercolor="grey" border="1" class="container"> <tbody> <tr> <td colspan="2"…
-
0
votes0
answers554
viewsUsing Foreignkey to save to BD Django
I cannot do Data’s relationship with Teacher, I have to save Teacher and pass his id to Data foreign key and save, when I execute the code id is not passed Forms.py class…
-
0
votes1
answer126
viewsRelationship in database table
I have a registration form where contains personal information, professionals, additional, financial and production, my doubt, as it gives many columns, I believe that more than 50 fields. Is it…
-
0
votes1
answer84
views$('#type'). val('juridica');
I am having a big problem in receiving and sending the data to the database because, when creating a system where there is the possibility of using the physical person or legal person, they send to…
-
0
votes2
answers94
viewsDynamic data entry in 2 tables
Good afternoon, everyone. I have the following situation: In a vehicle registration module need to dynamically register and at once a vehicle followed by all its models and group, and a vehicle can…
-
0
votes1
answer50
viewsCreation of multiple dynamic lines in an oracle table
I need to create a new table with multiple rows using data from a previous table as parameter. For example _______________________ | nome | quantidade | |--------|------------| | xyz | 2 | | abc | 1…
-
0
votes1
answer295
viewshow to make combobox modify a combobox with java desktop database items?
I managed to do but only works with pre-selected items. CidadeDAO cidadeDAO = new CidadeDAO(connection); EstadoDAO estadoDao = new EstadoDAO(connection); List<ModeloEstado> estados =…
-
0
votes1
answer470
views -
0
votes1
answer453
viewsHow do I create templates in iReport?
I wonder if there is any way to use a template created by me in other reports? I want all reports in my system to follow a pattern, but how to do this?
-
0
votes1
answer84
viewsCreate user using a Function
someone could help me, she keeps giving error when saved '-' Error(19,5): PLS-00103: Encountered the Symbol "CREATE" when expecting one of the following: ( start case declare quit for goto if loop…
-
0
votes2
answers38
viewsList of Tables
Creating my Migrations in Laravel I came up with the following question: I have these two tables: Used ID NOME_MARCA_ID MODEL YEAR BRANDS ID NAME in Migration to keep the brand ID I would do so:…
-
0
votes0
answers23
viewsRegistration with empty column affects performance at query time
Let’s say I have a table with 4 columns and 4 records. Not all columns are filled in at the time of the form because it is not mandatory, so the database has some gaps in its grid! Example: ID |…
-
0
votes2
answers59
viewsAccentuation of the database not accepted on the site
I have a text in the database but the site does not assume the accentuation of type ã, á, ç and puts in place of those letters some strange characters: My database is with latin1_swedish_ci grouping…
-
0
votes3
answers240
viewsHow to read DBF generated in Protheus in Visual Fox Pro?
I ran a DBF in the Protheus and I am having difficulties to open the file in Visual Foxpro, as it does not recognize the file returning the message: dbf file is not a table. Has anyone been there or…
-
0
votes0
answers75
viewsI created a db with Wamp but when I click on the folder to see my php files n appears nothing
In phpmyadmin db is ok, but when I click on the folder that has the phps appears: It is not possible to access this site Could not find DNS address of Folder Name server. My wamp is green and…
-
0
votes1
answer1041
viewsOnclick problem, I cannot pass Array information to a text view
I’m having trouble inflating a list with information from the bank, I want to take the user information and set it in a list, but only with a type of data as a name, however it presents the…
-
0
votes1
answer129
viewsApplication to make emergency calls
I am trying to make q my application make an emergency call by clicking the button, however while running it presents the following error: ERROR: FATAL EXCEPTION: main Process:…
-
0
votes0
answers294
viewsExternal and internal database
I’m a beginner in programming Android and I am with a doubt... it is possible for the same application to have an internal and external database at the same time? For example some information is…
-
0
votes1
answer120
viewsHow to use Sqlite in Qt 5.7 with Android
I would like to know how the communication with the database is done Sqlite on android using the Qsqldatabase? I performed some tests and for desktop I can perform the communication with BD, but…
-
0
votes1
answer1179
viewsQuery between different databases in SQL Server
Given this query: SELECT PontoSecullum4.DBO.funcionarios.N_FOLHA, PontoSecullum4.DBO.funcionarios.NOME, PontoSecullum4.DBO.funcionarios.EMPRESA_ID, 1 [ORIGEM] FROM PontoSecullum4.DBO.funcionarios…