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
-
2
votes1
answer231
viewsDesign standard to combine data from different databases
I’m taking data from two different databases and need to format this data for Json. The problem is not accessing the two banks and getting the information. The problem is that my class became more…
-
2
votes2
answers145
viewsModeling Database
Specifying the tables I’m doubtful are, in my case, a work of a company for the college, the tables: Input and Diagnosis, in which the input is when someone brings some equipment, and then is made…
-
2
votes1
answer705
viewsHow to join the two tables in this case?
I have two tables a "students" with the enrollment and enrollment and another "faz_teste" with the grades of the students in certain tests. I used the pivot command in the table "faz_teste" to…
-
2
votes1
answer7504
viewsHow to display a photo from the database?
I can’t display the photos I’m sending to the database. I’m making a comment system with photo and managed to send them to the database (mysql). I created my database, then my table. I made the…
-
2
votes2
answers763
viewsRecover the value of an attribute of a generic object in Java
I’m making a system where I read Java objects of different types of XML files. So I don’t have a single object type and consequently I don’t know its attributes or methods. I would like to perform a…
-
2
votes1
answer1421
viewsInner Join - return by name id in column of another table
I have two tables in DB: table category: id_categoria | nome_categoria 1 camisetas 2 estrelas table post: id_post | título | resumo | conteúdo | categoria_id 1 teste lorem ipsum 2 2 test2 lorem…
-
2
votes1
answer87
viewsAuthentication in different databases
Hello, I am developing a web service (in java) of integration in different databases and I ended up falling into a problem in which I am not finding a solution. Queries are entered manually and will…
-
2
votes1
answer1170
views"Syntax error: Missing 'semicolon'" in Mysql database
I have the procedure down below CREATE DEFINER=`root`@`localhost` PROCEDURE `SP_notasAluno`(IN aluno INT) BEGIN DECLARE ditCodigo,courseId INT; DECLARE usuario VARCHAR(50); DECLARE…
-
2
votes2
answers615
viewsHow do I create a connection to an external db with a Phonegap app?
I’m entering and studying the world of Phonegap/Cordova and I want to start developing cooler and more interactive apps, but I’m finding this limitation, in most of the places I find to learn, the…
-
2
votes2
answers56
viewsField of type time or decimal, how to solve?
I have in the system that I am developing a field called flow, which can be filled either with a decimal value like 0.5 and 2.4 or with a value of time, like 15 min and 5 h. What is the best…
-
2
votes0
answers687
viewsDatabase with QRCODE
Good morning guys, I want to generate a QRCODE that pulls information from a database, on android I will make the QRCODE reader using some api zxing or Barcode. Has anyone ever done anything like?…
-
2
votes1
answer241
viewsHow to make a "select distinct" on a model in Laravel?
I’m pulling the data from a table to a select, but I have fields where the information is equal, for example: Controller: $amostragens = Amostragem::all(); View: @foreach($amostragens as…
-
2
votes1
answer118
viewsSaturation of Foreign Keys?
After a long time with non-relational database I decided to come back and I came across a strange situation. My app is a simple chat where this chat has sub rooms. I did a little demonstration: I…
-
2
votes2
answers61
viewsDatabase overloads while deleting lines with relationships?
Good afternoon to all! I have a question, and I’d like to get some opinions. I’m building a system in php + Larable. I have relationships between tables, for ex: Users->Roles. They are supposed…
php database laravel table relationshipasked 8 years, 6 months ago Fernando Herique Rubim Pioli 285 -
2
votes2
answers644
viewsError in select with PHP + Mysqli
I’m trying to use a query to pull one ID specific that comes from another page. I can receive the ID for $_GET, i printed the query to see if it was right, even so of the error and does not show me…
-
2
votes1
answer390
viewsHow to transfer the row of a table in column
I’m breaking my head with a problem, I need the information of a column, built through query, to turn into line (query header). I saw some tutorials and related debts but could not implement: PIVOT…
-
2
votes1
answer90
viewsNotification on a local network with Postgresql
I would like to know how to send a simple notification to users of a local network, send a notification to all other devices with the app connected to the Postgresql database...
-
2
votes1
answer289
viewsSql Reader returning null value
I’m running a datareader, however does not return any value, already checked in the table and conditions (where) of select exist in the table. The code goes below: public void consulta() { string…
-
2
votes2
answers794
viewsRadio button check with BD data
I’m having trouble taking the data from the database and passing via Session to my form, all the input data is coming correctly, I just can’t pass it as check for my radios... I tested in various…
-
2
votes1
answer87
viewsWhere are the databases saved in SQL*Plus?
I downloaded SQL*Plus on the Oracle website, installed (my notebook is Windows 10) created user and already created some banks, but do not know where it saves the banks I created. Where is?
-
2
votes2
answers1743
viewsHow to register and query data in the Wordpress database?
On my website, there’s a section called "My Ideal Board". It is a form where the user will enter their data and there will be a return message with the type of plank ideal for the person. First…
-
2
votes2
answers2146
viewsIs it possible to connect a C-based application to a database?
We usually use files to save data using language C (at least). It is possible to connect a relational database to any application made in C? If yes, do you need a library for this and how is this…
-
2
votes2
answers433
viewsConnection database in Unity
I am developing a game in Unity and we have reached the part where it is necessary to store players' scores in a database. This information will be used in the rank that will appear at the end of…
-
2
votes0
answers434
viewsHow to Create 15 minute SQL Interval?
I have a field timestamp and I need to create an interval every 15 minutes. How in Sql I should do this ? Data = YYYY/MM/DD HH:MM:SS The purpose is an analysis where I need the amount of products…
-
2
votes2
answers254
viewsDifference between relational table and online record
I have a structure of companies and categories organized in 3 tables: empresa -> Registration of all registered companies. categoria -> Registration of all registered categories.…
-
2
votes1
answer104
viewsmysql - row for Gravity Forms columns
Good afternoon, I’m pretty new to database and programming, but I like to move when necessary. I have a table in the database with responses from a form made in wordpress by Gravity Forms that…
-
2
votes2
answers581
viewsDifference and sum of DATETIME column
I have a table called chamado_processos with the following structure and data As you can see one of the columns of this table called dt_processo is a field DATETIME and the column tp_processo…
-
2
votes1
answer108
viewsConvert tuples from different databases into a particular Java object
Well folks, I don’t know if the title of my question is quite correct, if not, someone please edit. I’ll explain my problem. I developed a tool that checks conflicts between access control policies…
-
2
votes2
answers1842
viewsHow to import ACCESS data to MYSQL
I have a db ACCESS with many tables and a lot of recorded data, I need to import these tables for my new dbin MYSQL. someone knows a way ? or a tutorial to follow ? I’m using Mysql-Front and…
-
2
votes1
answer39
viewsHelps storage in XML file
good afternoon! I’m developing a system for product registration. However, I am thinking of creating an XML file to store the general characteristics of the products (the other information will be…
-
2
votes1
answer1043
viewsDatabase Request API For Angularjs
What API’s to make requests with database (mysql preference) that I have available to work integrated with Angularjs, some that is simpler to use and that runs on any server, I was going to use the…
-
2
votes1
answer120
viewsGenerate the primary key in the application or keep it auto-incrementable?
Should I set the primary key of my table as auto_increment or define it as numerical, generating the key within my application? Contextualization I am developing a C# application and testing it in…
-
2
votes1
answer728
viewsMysql and PHP Dynamic Form - Codeinigter
I need to create a form to create evaluations, with a number of variable questions. For this I created a form that adds questions, as requested; The problem is saving banco de dados this variety of…
-
2
votes1
answer415
views -
2
votes1
answer5339
viewsPHP - How to configure . env from Laravel to access different databases and different languages?
I am working on a system (portal) that offers service to 19 countries. For each country there is a database and each country with its language dictionary (even countries with the same language, have…
-
2
votes1
answer47
viewsMysql giving error only when using query via variable
I am trying to save information in my database with the following functions: $sql = $request[0]; $query = $this->conn->prepare($sql); $query->execute(); var_dump of $sql: string(322)…
-
2
votes2
answers5168
viewsRelational database model with SKU
I am creating a system for selling products and I need that these products can have different prices according to their size or color, for this I am using SKU, I am creating the relational model of…
-
2
votes2
answers805
viewsGroup by by two fields ordered by a third
I have the following data: |--------------------------------------------------------| |USER | ID | DEVICEID | DATE | |--------------------------------------------------------| |7 | 14450 |…
-
2
votes1
answer521
viewsMysql Create a database for a single user
I want to create a database where only one user can access the information. Although there are already users created on the server, but only the user I create has to be the only one to have access…
-
2
votes1
answer347
viewsAuthentication via social networks
I am implementing authentication via Facebook and Twitter, and later other networks, but some doubts arose. What would be the logic for creating a new account when the user authenticates via social…
-
2
votes0
answers179
viewsAuto ID increment relative to another field
I have been looking for something to solve such problem that I have been finding in other systems that I developed, I would like to know a solution for how to make an id auto increment, but an auto…
-
2
votes1
answer102
viewsPerform action for each line in an SQL search - VB
I wonder if anyone can help me with the following question. In a VB code, I want to perform the search for products in an SQL table. For each product found I would like to add a button in a panel.…
-
2
votes0
answers45
viewsAlgorithm to match department, category, and subcategory of a BD with a received string?
From a non-standard string, I sometimes receive the equivalent of department/category, sometimes equivalent to category/subcategory, sometimes equivalent to department/subcategory, sometimes…
-
2
votes2
answers828
viewsHow to connect a Mysql database with QT on a local network?
Hello, at the moment I am Noob in manipulation of servers with databases. I am using Qt Creator 5.3 to develop my project, and have decided to incorporate a Mysql 5.7 database into it. I am trying…
-
2
votes3
answers10183
viewsWhat is the difference between UNIQUE and PRIMARY KEY in Oracle?
I’d like to know the difference between UNIQUE and PRIMARY KEY in the Oracle, whereas UNIQUE defines values that cannot be repeated, and PRIMARY KEY in thesis does the same thing.…
-
2
votes1
answer324
viewsHow to do While from one table and show data from another?
I have two tables: Tabela1: Id int A_I; Modelo varchar; Tabela2: Id int A_I; Id_fk int (foreign key da tabela1); cor; And wanted to do a Tabela1 while but show table data2. <?php include…
-
2
votes3
answers76
viewsIs there any difference in performance depending on what you seek?
There is some difference in performance when searching the database, depending on the number of characters reported in the query? For example, if a query is made for any record that has the…
-
2
votes1
answer445
viewsGroup query by similar but non-identical records
I need to migrate a database (from SQL Server for PostgreSQL and I’m creating a ETL interactive in PHP to make this change), which is about 10 years old, about 2 million records in the clientes that…
-
2
votes1
answer80
viewsWhat Types of Postgis Data Are These
In the Postgis 2.3 documentation in Part 4.2 Postgis Geography Type, it is mentioned that the following types are supported. POINT LINESTRING POLYGON MULTIPOINT MULTILINESTRING MULTIPOLYGON…
-
2
votes0
answers287
viewsJSF + Wildfly multi-bank connection dynamically
Hello, I have a web application using JSF + CDI + JPA and Wildfly 8 as the application server. So far I’m letting the server manage transactions, where the connection information with the database,…