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
votes1
answer177
viewsPre-development questions about android app with data synchronization
I would like to make a simple application to register users using java. But this app should keep a local database for offline data access and a cloud database to sync the information when I click on…
-
1
votes1
answer147
viewsUpdate tables with the same data in the row
When I add a category A, and add a product X with the category A (table categories), then edit the category name A for category B, the category of product X (products table) remains with the…
-
1
votes1
answer59
viewsProblems with connection to the database
I have an error that could not connect to database on line 125 in the file I will leave here. 'Cause they handed me a website but I don’t understand anything about you. I have to call (for testing)…
-
1
votes1
answer510
viewsDesktop App + DB Online (Hosting)
Good afternoon, Guys, my question is the following, in my connection of a desktop application with online database: 1st question: What is the best way to stay safe the connection made with the…
-
1
votes0
answers175
viewsMS Access 2013 ERROR - No unique index found for the primary table referenced field
I’m learning MS Access 2013 and trying to create relationships with 3 tables. When I link them without the option Enforce Referential Integrity the relation is generated, however when I put the same…
-
1
votes1
answer2143
viewsDatabase modeling helps you!
I need to make a library system for book loans, in which I drew up this database diagram. The professor said that this diagram is inconsistent. What needs to be done, it’s just these tables that I’m…
-
1
votes1
answer583
viewsListview of Android database - Close application with error
I’m implementing a registration with Sqlite3 on Android and so far okay, the problem is in the call of Activity data listing when the registration is successfully performed, when making the call to…
-
1
votes1
answer79
viewsCannot add or update a Child Row
Good, I have these tables with the following structures: Athletes: id_atletas id_identificacao nome_completo licenca Identification: id_identificacao nome_pretendido data_nascimento The…
-
1
votes1
answer271
viewsInsert current date in Database
I have a database with a table Noticias with: Id (Primary key and auto_increment) News (varchar, where I write the news) Date(where the current date has to be, only dd/mm/yyyy) but I never messed…
-
1
votes1
answer62
viewsPHP Database Search
I have a database with 3 tables and I need to know if in table A (for example) the field guy for 0 will fetch data from table B, if for 1 will fetch data from table C. And I have the following code…
-
1
votes1
answer2399
viewsMER - Entity and relationship model
I wonder if my MER is correct and if it is possible to make a relationship N:N between animals and schedules. Specifications I created for the system: Computerize the scheduling of a bath and Osa,…
-
1
votes0
answers51
viewsPass values from a Gridview to a database
I would like to know how to take the values of a gridview in windowsform and pass to my database in Access.
-
1
votes1
answer1342
viewsAvoid saving duplicate data
In my project I have a rule that is not to save and not to show in Grid duplicated data. For example, in the system I read a XML and with the exception of tags in a table in my database so that this…
-
1
votes1
answer423
viewsMake anime and manga gallery in c# desktop
For you to read an online manga, you have to go to some sites like "Mangasproject" to see what was released and view the manga to read. I want to do an anime gallery to store photos and description…
-
1
votes0
answers69
viewsDifferent Date Format
Sirs, I have the following code: $funcionario_blocodcon_novo = array(); for($i=0;$i<count($funcionario_blocodcon['localtrabalho']);$i++){ foreach($funcionario_blocodcon as $key=>$val){…
-
1
votes1
answer263
viewsHow to integrate one database table into another?
Example: A system that records customers, purchases and products, each in a different table. Having a purchase record that must own the fields: Client: indicates which customer already registered…
-
1
votes1
answer54
viewsSend newsletter
I’m trying to send a newsletter to all users who have enabled the newsletter and I’m not getting. My code to send one email normal is: try { SmtpClient smtp = new SmtpClient();…
-
1
votes2
answers456
viewsOpen Progress bank
Good afternoon, I need to open a client’s Progress database to make an import and I’m not getting it. I need some help to know some way to work with this bank, whether by code or applications. these…
-
1
votes1
answer587
viewsError: Parameter index out of range (1 > number of Parameters, which is 0)
I am trying to remove a data from the bank, but the following error happens: Parameter index out of range (1 > number of Parameters, which is 0) Can you help me? public void remove(Bean e) { try…
-
1
votes1
answer68
viewsConfiguration table
How could I use a configuration table in nhibernate? That is, a table of only one record and that it only controlled this record, I know you have how to do this via application, but I wanted to know…
-
1
votes2
answers595
viewsDatabase in Android
Hello! A few days ago, in a question I asked here at Stackoverflow, I said I was starting to develop for the Android platform. This week has been very productive and I already have some ideas to…
-
1
votes1
answer5793
viewsHow to close all active connections?
I have 8 open connections in the database and would like to close all of them, is possible? What is the Mysql command that does this?
-
1
votes1
answer4981
viewsHow can I save checkbox in the database with php?
I have several checkbox components on the site, each with the value of a movie name, how can I save in the bank? HTML of one of them: <input type="checkbox" class="checkbox" name="filme"> Do…
-
1
votes1
answer134
viewsProblems with html formatting
I have an image upload with text on a website and after inserting shows the images and text. The upload saves the images in a folder and yours path in the database. It’s supposed to look like this:…
-
1
votes3
answers2299
viewslimit no codeigniter
I have a code that takes data from the database and shows them in a table. I need it to appear only the first two records. For this I put a limit on my code. Only it is not limiting, but taking the…
-
1
votes2
answers174
viewsProblem with Sqlite Android Data Base
So my problem is this one, I’ve tried and researched everything but I couldn’t implement any solution. I tried to update the database with the update and also insert new columns with ALTER TABLE,…
-
1
votes0
answers38
viewsDatabase does not work after formatting the computer
Guys, here’s the thing... my computer is divided into two units, C and D. The program I used is in Delphi 7, was in the unit D and used a Firebird database. When I Formatted the Drive C, reinstalled…
-
1
votes2
answers805
viewsIs it correct to use JSON to store data that does not need to be in a database?
Ex: In the company where I work they have put in my code a large amount of data that does not need to be in the database, but is not text or actual content. They are a lot of validations and…
-
1
votes0
answers218
viewsAccess Database File, SYBASE
I need to remove the data from a database file (.db) that I was told is SYBASE, the client needs to migrate data and I need to access, does anyone have any idea where to start? because never heard…
-
1
votes1
answer246
viewsWhat kind of conversion does the pre-compiler of a DBMS with the SQL language?
The compiler of a DBMS handles commands written in SQL. Assuming I’m using Mysql. What would be done with the command: select * from client; What type of conversion does the pre-compiler of a DBMS…
-
1
votes0
answers83
viewsError updating Indexeddb version
I’m having trouble updating the version of Indexeddb, it presents the following errors. Uncaught Constrainterror: Failed to execute 'createObjectStore' on 'Idbdatabase': An Object store with the…
-
1
votes1
answer1546
viewsSQL query grouping by age group
Hello, I need a way to make an sql query that brings me the amount of male and female people. OBS: I have two tables where the first one is registered in it I have the sex column and another table…
-
1
votes1
answer299
viewsError when connecting ORACLE database with PHP
When trying to connect to an Oracle ORACLE database appears the following error: TNS:System was not Given the SERVICE_NAME in CONNECT_DATA I have already set up php.ini and included the following…
-
1
votes1
answer444
viewsTreat session by codeigniter model or controller
I’m trying to send the data from the database to the session, gave a print_r on the data received from the bank, but I can not pass it to the session, follow the code. Controller <?php…
-
1
votes2
answers224
viewsDoubt about Indexeddb
I’m needing to do a many-to-many table on Indexeddb, where I have People Classes and People Classes, one can participate in several classes, and several classes can have several students, so I…
-
1
votes0
answers72
viewsHow to display the result of a view (view) (posgreeSQL) on a PHP html page?
Hello!! I am creating a web platform with connection in postgree and I came across this obstacle. I don’t know how to display a query (view) in the HTML form receiving information from a listbox.…
-
1
votes1
answer45
viewsHow to maintain orderly list of records in relationship N:N
Considering a scenario where a author can hold several publications and a publishing may have several authors, we have an intermediate table to maintain relationships. However, the order of authors…
-
1
votes1
answer90
viewsHow to register each new relationship between two entities
Considering a scenario where a member has a account, personal profile, academic profile and may vary between status (between pre-defined status: teacher, student and collaborator) within the system.…
-
1
votes2
answers899
viewsHow to use Firebird database on network with C#?
I developed a C# Windows Forms application with Firebird database and I need to place the application with the database on a machine that will be like a server. With this, I need to access this…
c# database visual-studio-2013 firebird networksasked 8 years, 11 months ago André Morais Martins 367 -
1
votes1
answer920
viewsHow to return all results from the [PDO] database?
I’m doing a function to return all the results of a database. The function in this exact format returns me only one result but putting echo in each statement returns me all the results. How can I…
-
1
votes2
answers172
viewsQuery Performance in Mysql
I have in my form the option to perform a search for Rg or Cpf. So I got the question about the performance of the query using the following code: SELECT * FROM DADOSPESSOAIS WHERE (Rg = @Rg OR Cpf…
-
1
votes1
answer51
viewsHow to connect a Query to a Container?
TypedQuery<Empteste> minhaLista = em.createQuery("Select d from Empteste", Empteste.class); List<Empteste> results = minhaLista.getResultList(); I want that my list result to appear in…
-
1
votes2
answers141
viewsDoubt about mysql - Save, Update and Show data
Talk guys! I have a question. I created a static page that will show some data. For example, I want to show you the live score of a specific football game. I thought of creating a static page with:…
-
1
votes1
answer114
viewsBank related creation
I am doubtful whether or not I am doing the right thing in setting up this bank. They could help if the way is right or wrong. For now I just put id in the tables. Gang Turma | Turmaid A 1 B 2 C 3 D…
-
1
votes2
answers295
viewsUnknown command: 'syncdb' Visual Studio 2013
I’m having trouble developing a system in Django. When I try to synchronize the bank this error appears: Python interactive window. Type $help for a list of commands. Executing manage.py syncdb…
-
1
votes1
answer298
viewsCount in Postgresql using OVER
I have a teacher evaluation table and another with student evaluations: tbl_teacher id | nome ---------------------------- 1 | José 2 | Maria 3 | Paulo tbl_evaluation id | idprofessor | avaliacao |…
-
1
votes2
answers182
viewsLocal database (serveless) not modifiable with update
Setting: I’m developing a small app WinForm in C# to distribute to sellers to assemble their quotes more quickly and would like to store simple information such as budget issued and registered…
-
1
votes2
answers106
viewsError changing static property value
I have my class DadosConexao, this class is responsible for storing the connection string of the database, it contains the following properties: A statistical property StringConexao. isServ…
-
1
votes2
answers586
viewsApplication does not save data and only saves code
I’m developing software for a video rental company with Pattern MVC design (Model-view-controller) and the problem of not saving people is occurring. It only saves people’s code and I don’t even…
-
1
votes2
answers134
views'system.outofmemoryexception' while opening . dbf 300 mega file
I try to open a file . dbf from 300mg in my code, but this error appears '$Exception. Message' threw an Exception of type 'System.Outofmemoryexception', a smaller file of 300kb is open normally, I…