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
answer1825
viewsAllow a user to view stored procedures created by other users
I have a Mysql database populated with some stored procedures. The problem is that two different users have created several procedures, so that only the user who created the stored Procedure can see…
-
2
votes1
answer78
viewsSearch information in more than one table
In my project I currently have 3 tables: Students, Occurrences and Users. In them I have the views and the controllers. So far, so good. My relationships are: Allunos&occurrences(1,N) /…
-
2
votes2
answers1315
viewsConvert Empty string to integer to insert into database
How can I convert an empty text field (Jtextfield for example) to an integer, and then insert it into the database? I have fields in the database defined as int, but when the user does not fill in a…
-
2
votes1
answer133
viewsRegistering multiple images in one post
I’m with a study project that has to create a kind of gallery. Assuming I have a limit of 20 images per post. How to register these images in the database? I thought of two hypotheses. In the first…
-
2
votes1
answer1890
viewsWhat is the real use of Sqliteopenhelper on Android?
I was watching a course online devmedia explaining about Sqlite on Android, in the example of the course was made a basic crud, were created 1 bank and 2 tables. In the example, I was creating two…
-
2
votes1
answer557
viewsHow do I insert any file extension into an SQL database?
I always worked attaching only images in my BDD tables, I remember that converted to MemoryStream and then to Byte and inserted... But I need to insert any kind of file extension in my database.…
-
2
votes1
answer1670
viewsPassing parameters to the postgresSQL
I will create a Rigger in postgresql to copy the information from one table to another, the tables will always have the same structure, so I intend to pass the table names, make a WHILE and copy the…
-
2
votes2
answers40
viewsDatabase normalization with 'parent services' and 'child services'
I am modeling a database which services belong to a category (used in most cases). Currently, categories are defined in the service table itself with a 'level' flag where I say whether that record…
-
2
votes1
answer37
viewsHow to apply a setNull(index,Types.Blob)?
How can I enter null in the database if an image is not loaded? FileInputStream cabecalho = null; conn.setAutoCommit(false); File fileLogotipo = new File(imagemCabecalho); //imagemCabecalho = path…
-
2
votes1
answer1120
viewsRetrieve data from fields of the same name but from different tables
I have a select that looks for data from three different tables, but has some common fields between these three tables. My question is how to get the data of these fields, which has the common name…
-
2
votes1
answer2262
viewsDER for student, discipline and course
A student can only have one course. A course has several disciplines. The student can take several courses of the course. My only doubt is what it would look like on the DER? Would really look that…
-
2
votes1
answer247
viewsHow to insert data into mysql via ajax + php + Foundation 5
I was wondering how can I insert data into Mysql via Ajax + PHP using the Zurb Foundation 5 Framework? The "data-Reveal-ajax" property of the framework already replaces an Ajax insertion function?…
-
2
votes1
answer97
viewsConexões Clonadas
I wonder if there is how to create only a connection to the database to perform the tasks. With each Action executed, a connection with the Database is created and at the end of the Action…
-
2
votes1
answer521
viewsHow to maintain a real-time sync?
I’m working on an app, and I’ve got the database processed. But a question arose of how I can create a real-time synchronization system of the app’s local database with the remote server database.…
-
2
votes1
answer249
viewsError when exporting SQL Server database to another Server
I have a database on an SQL Server Web Edition (64-bit) server (11.0.5556.0) and need to export it to a server with SQL Server Express Edition with Advanced Services (64-bit) (10.50.4297.0). When…
-
2
votes2
answers79
viewsAdd a login field to an existing user table
What would be the best way to add a field of login in an existing database table with about 10,000 users. I am currently using Mysql and would like to remodel the user table, at the moment the table…
-
2
votes1
answer366
viewsTables with columns always null
Is it considered wrong to create tables with mutually exclusive columns? For example, I have tables Texto, Trecho and Linhas, whereas Texto and Trecho has many Linhas, the table Linha is holding the…
-
2
votes1
answer271
viewsDatabase with extra headers
Does anyone know any database in which, in addition to the traditional architecture (rows and columns), we could create and manipulate FIELDS, which would be available for reading and writing and…
-
2
votes1
answer749
viewsHow to get the affected line number in an Mysql Insert
In Sqlserver I use after the insert or update i use: SET @LINHAS_AFETADAS = @@ROWCOUNT So I get the affected line number, I would like to know what the equivalent in Mysql, I searched the web but…
-
2
votes3
answers458
viewsSearch database table information with PHP every 10 minutes
I need to search for information from a database table every 10 minutes using PHP. Does anyone have any idea how I can do this?
-
2
votes2
answers91
views -
2
votes3
answers877
viewsDoubt in Insert, update and delete with Codeigniter Framework?
I have a question related to insertion, alteration and removal of records in the Mysql database. For example, imagine a banknote table, where all the information in that note is recorded, such as…
-
2
votes2
answers93
viewsRepeater for many lines
I have a problem in an application I am developing where I have a database with approximately 20 million lines. The problem is that the user wants to see all these 20 million lines on a single…
-
2
votes1
answer523
viewsError creating a NOT NULL field in PGADMIN " contains null values "
I have a database already created, within it I have a table already created. In it I need to create a field that is NOT NULL. I do everything by the graphical interface that is faster, I click on…
-
2
votes1
answer337
viewsIs it advisable to have a Users table relating to others?
I am beginner in systems development, and I would like to know if the table of users of the system could establish relations with other tables, as for example, the table of company.
-
2
votes2
answers40109
viewsGet values from one table that are not contained in another
I would like to know how I can get values from a mysql database and the data obtained should be in one table and not in another. For example: I want all equipment (equipment table) that is not…
-
2
votes2
answers2709
viewsHow to create a connection to the H2 database using Spring Data?
They played in my lap a project that will be done with Spring Framework and want the data persistence to be done with Spring Data. I’ve never worked with either of them and I’m having a profound…
databaseasked 9 years, 6 months ago Paulo Magno Rodrigues Salum 63 -
2
votes1
answer479
viewsTable structure for PHP friendship systems
I am developing a system of friendships in my system and would like to know the best way to organize the table that will take care of such records amigos: I’ve thought of something: Tabela "amigos"…
-
2
votes1
answer258
viewsIs it possible to include database versioning in the commit (GIT)?
I wonder if it is possible to versioning the database (in my case Mysql) through GIT, or if there is some other effective way to do it.
-
2
votes1
answer1161
viewsHow to send information from a dynamic form?
I have to make a form in which I will have this table, only instead of being static it will be dynamic, one can enter 1 familiar, 2 ,3 ,4, 10, whatever she wants. That’s what I’m using it for…
-
2
votes2
answers401
viewsErro Foreign Key
I’m making a database rather simple for presentation of a work and I’m finding the same annoying problem. In this case we have two tables, funcionario[nome,cpf] and departamento[DNR,CPF do gerente].…
-
2
votes1
answer1573
viewsError "Insert value list does not match column list" with PDO
Hello, I’ve made a questionnaire, and it’s returning the following error: Error: SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1…
-
2
votes1
answer103
viewsDatabase stops working after a few hours
Hello, in this registration system, I get the information entered and play in a database. include("connection.php"); require("blowfish.php"); $login = $_POST['login_cadastro']; $senha =…
-
2
votes1
answer1250
viewsHow to search for similar words or synonyms in Postgresql
I need to get a survey to return similar words I found the phonetic research it can even be used to refine the search I need, but I think this is not ideal. For example, in a database I have several…
-
2
votes1
answer335
viewsIt makes a difference to use LONGTEXT instead of VARCHAR(255)
I wonder if using LONGTEXT instead of VARCHAR(255) would cause more "lag", which would have a greater advantage ??
-
2
votes4
answers504
viewsFilter numbers not yet registered via SQL
I’m trying to find the numbers that haven’t been entered in the bank yet. I have a client table, in it I have the fields codigo and nome. When the user registers the client, he puts the code…
-
2
votes2
answers159
views -
2
votes2
answers602
viewsCombobox and database connection
Good afternoon! I’m having some difficulty submitting the combobox data in listview due to an error that appears and I can not solve. The mistake you make is this This here is the code where the…
-
2
votes1
answer2396
viewsConnect Mysql Workbench to Hostinger Server
Several times I tried to connect the Mysql Workbench to the database of my website hosted on Hostinger.com.br but always makes a mistake. From what I understand the access data I am passing are…
-
2
votes1
answer446
viewsTaking data from the checkbox and sending it to the bank
I am creating a form and need to send to the bank the selected checkbox. I have the table conta, conta_categoria and categoria. In the conta_categoria have the id_conta and the id_categoria. How…
-
2
votes2
answers107
viewsApplication database query made in C#
I am creating an application in C#, but a question came to me. Which database is used so that it is not necessary to install the database in the client’s system? For example: If I were to use…
-
2
votes2
answers267
viewsLock F5 key in the application
Good afternoon, I am developing a Java Web application, and found that after performing a registration and typing F5 the information gets duplicated, only the ID that does not duplicate because it…
-
2
votes1
answer572
views -
2
votes1
answer51
viewsHeader does not work
Boa Pessoal, I have a php file that is named after filling a form in an html file. The function of this php file is to add data to the database and after inserting it has the following code:…
-
2
votes2
answers711
viewsHow to persist the String of an Enumerator in the Database?
I have the following Enumerator: public enum ETipoCasa{ Propria, Alugada, Financiada, Cedida; } And I’m trying to persist in the database the string of this enumerator as an example: Casa casa = new…
-
2
votes2
answers54
viewsI can’t delete key in dbm
I made a basic program to store some data and I am in trouble if the user chooses the option to delete some stored dictionary key. The function that erases data in my program is this: def…
-
2
votes1
answer646
viewsSelect of cities and states on the site
I’m riding a website, and on the home page I created a select for states and cities, the problem is that the home page of the website is catching up too. Does anyone know how I can do this select…
-
2
votes1
answer117
viewsHow to save in a database, confrontations between teams?
I would like to know how to save in a table in the database clashes between teams, for example: TIME A x TIME B TIME A x TIME C TIME B x TIME C
-
2
votes2
answers198
viewsListview infinity on android
I have an app that consumes a web service, only I have a generic call that searches all users and this taking a long time because I have several records, I want to do so the user goes down the…
-
2
votes1
answer721
viewsEntity Framework associative table mapping
Abstracting some details I have these classes: public class Department: Entitie { public string Description { get; private set; } public DateTime CreateDate { get; private set; } public virtual…