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
answer742
viewsDelete record button does not work
I have a query page that shows the entries made in the bank through a form and a button with the option to delete. Page of the consultation: <h1 style=" text-align: center; height: 7; margin-top:…
-
0
votes1
answer260
viewsGet the repeated records from one column from another column
Hello to all! I am facing the following problem: I want to get the amount of values that repeat in the column disease type from the column of locality, that is to say, take the amount of records…
-
0
votes2
answers7832
viewsHow to make a search filter
I have a query page that shows in table form the records registered in the bank through a form. Considering that there’s going to be a point where the system is going to have a lot of criminal…
-
0
votes1
answer24
viewsPHP page connects to the database, loads but does not delete
Could you help me identify what’s wrong with this code? <?php include ("conexao.php");?> <?php $id = isset ($_POST['id']) ? $_POST['id']:''; $sql= "DELETE FROM `guaxinim` WHERE…
-
0
votes1
answer43
viewsPostgresql: Catch amount of errors and hits
I need a query to get amount of errors and hits from this table.…
-
0
votes1
answer59
viewsSee how many Products were sold in 2017
I’m having difficulty making this query using BETWEEN, this is the model.…
-
0
votes1
answer1140
viewsTrigger to upgrade stock
I’m trying to create a trigger to update my stock of products, when the status of my purchase is closed (CF = Closed Purchase). However, it is sending me an error, and I could not identify what is…
-
0
votes1
answer1395
viewsSave date and time in database
I wonder if there is how I save the date and time of my system to be able to save in the database, I would not like to create a "created_em" and add the time in the database, what I want to do is…
-
0
votes1
answer472
viewsConsultation to calculate the number of female and male students
In this consultation I would use the GROUP BY? That and the model…
-
0
votes0
answers33
viewsProblem with postgresql server version Mismatch
I am trying to restore a base, small , I perform the backup on my machine in version 9.6 , but, alleges error when trying to create the backup via pgadmin III, executed through a bat : pg_dump.exe…
-
0
votes1
answer330
viewsHow to synchronize mysql database (security backup)
I have a website hosting files, (file server), I synchronize the files with another server.. in case something happens I have a copy of all the files.. But is there any way to always save a copy of…
-
0
votes1
answer303
viewsI cannot save form using spring boot
I’m starting to study spring boot now and trying to do a CRUD, but I’m having a hard time saving my form. No error message appears, neither in the console nor in the browser. I have already reviewed…
-
0
votes0
answers36
viewsdelete the records that repeat in the entire table minus 1 column
I have the following data: note that there are some Ids that contain more than 1 record, would like to delete the repeated record whose value is the lowest among the repeated ones the table may have…
-
0
votes0
answers246
viewsLink Combo Box to Mysql Database - netbeans
I created a database to store employees and departments. in netbeans I created the employee class and department with their respective ID, put a Frame with a combo box to pull all employees…
-
0
votes0
answers287
viewsModeling Banks Financial Institution
I am starting a personal project for my learning, an application simulating a financial institution system, first using the following products: current account, credit agreement (loans). I came…
-
0
votes0
answers52
viewsC#, sqlsever Popualar datagrid through Search
Personal I am having a difficulty, to make a call in my previous parameter is to type the name of the staff and bring the record in the grid. I’m using 3 layers, DAL, DTO, BLL; Can you guide me? How…
-
0
votes1
answer54
viewsError loading database information to a datagridview via Entity Framework
My project has four classes: public class Manifestacao { public long Id { get; set; } public string NumeroChamado { get; set; } public string DataHoraReg { get; set; } public Cliente Cliente { get;…
-
0
votes1
answer24
viewsWhat is a Distributed Cluster?
I am studying about database, specifically the mongoDB. So in the face of my ignorance, I would like to know what that expression, cluster distribuído or consulta em cluster distribuído, means.…
-
0
votes2
answers39
viewsHow to insert for all users in PLSQL when there is no data?
Good afternoon! I’m trying to insert to all users when there is no type entered for all users: INSERT INTO USUARIO ( TIPO, PRIORITARIO) SELECT '130', 'N' FROM dual WHERE not exists (SELECT * FROM…
-
0
votes1
answer1783
viewsHow to delete not only tables but a database in Sqlite
I would like to delete not only a table but the database as a whole in Sqlite. Searching, I was told of a method Context.deleteDatabase(), but I can’t use, if I try to call in a method, it says it’s…
-
0
votes1
answer331
viewsDoubt in database relationship of an application using spring boot
I am developed an application that aims to register a supplier, in which this supplier is Generico (can be a cafeteria, store building material, a pharmacy... etc) in which he will provide products…
-
0
votes1
answer100
viewsNetbeans 8.2 Error "java.sql.Sqlexception: Unknown system variable 'query_cache_size'"
I cannot connect to a Mysql database through Netbeans IDE, the following error is reported: java.sql.Sqlexception: Unknown system variable 'query_cache_size'
-
0
votes0
answers70
viewsOpen DB Berkeley Python
I received a project where I have a file . db I tried to open it with Sqlitestudio and Sqlitemanager, I was unsuccessful. I was informed that this db was a database Berkeley. I would like to open…
-
0
votes1
answer524
viewsHow to save a custom Enum name in the database?
I have an Enum Type which has a JURIDICAL person and a PHYSICAL person. I created a custom name (Legal) and (Physical). I’m getting to appear on the screen the custom name, but in the database is…
-
0
votes1
answer1755
viewsUncaught Error: Call to Undefined Function mysql_query()
I am doing my login system and is giving the following error when logging in: Fatal error: Uncaught Error: Call to Undefined Function mysql_query() thrown in D: xampp htdocs login.php on line 41 if…
-
0
votes1
answer37
viewsError after 100 AJAX requests
I have the function below that makes a request every second to the Mysql database and updates a DIV on the page. But after about 100 requests the "THINK ME" database blocks and returns "An error…
-
0
votes4
answers1125
viewsLoading an externally created Sqlite database
I need to use a previously created Sqlite database, already with records inserted in it. But the only way I had done until then was when the application itself created the bank, which I internally…
-
0
votes1
answer49
viewsWhat is the best way to save multiple image links in a database?
List<String> _lista = new List<String>(); [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(Veiculo veiculo, HttpPostedFileBase[] file) { for (int i = 0; i <…
-
0
votes1
answer340
viewsHow to compare two Oracle Datetime columns
I have a column where I enter a date when the event happens (local storage), and the date when the event is sent to my system. The difference between the date of the event and the date of dispatch…
-
0
votes2
answers41
viewsHaving products from the database
I need help because I need to have the products I have in my database on the products page. Follow an image to show where I want to insert…
-
0
votes0
answers99
viewsRefactoring a database using VIEWS
I have the task of refactoring a database and would like to know if VIEWs are viable for the task. My strategy is to create a VIEW imitating the new structure of the supposed table, at least the…
-
0
votes0
answers26
viewsSet value in Database session
I’m trying to use a database session SESSION_DRIVER=database I would like to know how to set the session in the specific column also I’m trying like this Session::put([ 'login' => $login ]); But…
-
0
votes0
answers58
viewsWhat is the best way to save data in real time?
Guys, can you tell me how to best save data in real time? For example, I have a news portal and need to save every access I receive and show on a private panel, but in case my site has 30,000…
-
0
votes1
answer685
viewsHTTP Status 405 - Method Not Allowed in the @DELETE method
I created a webservice that accesses a Mysql database, but I can’t delete records, I always get the following return: HTTP Status 405 - Method Not Allowed. The method Received in the request-line is…
-
0
votes0
answers244
viewsPartitioning MYSQL tables
Good night to you all. I have a question regarding tables in mysql. Assuming the following scenario. I have a MYSQL INNODB table with PK ID INT UNSIGNED. ( 4 billion records approx) 1 º If by chance…
-
0
votes0
answers24
viewsRest Server - Matrix/Branch
I have a Rest server that brings me the requests of the parent company, now the client has opened a branch. How do I have Rest log into the branch bank when the user logs into the local desktop. My…
-
0
votes0
answers119
viewsHow to access the Date tab from within the Android Device Monitor
Hello, I’m having a problem that I can’t access my tab even using the emulator or a physical device connected to the PC with a USB. This error may be due to some permission, but I don’t know how to…
-
0
votes1
answer40
viewsGenerate file D-1
How to perform the select of data in format D-1 (current day - 1), what would be in VBA a AGORA() - 1, how it would be in postgresql? I have the following query and would like to take yesterday to…
-
0
votes0
answers54
viewsMapping of web applications
Hello, I wonder if they know any Open-Source tools for mapping Web applications, I do not know what is the name for this type of application. Basically what I want to know about the applications is:…
-
0
votes1
answer48
viewsInsert users into different databases
I have two databases. Database A, and Database B. The user makes his registration in the database system A. I want to create a trigger for the same time, this registration also go to the database B,…
-
0
votes0
answers569
viewsDatabase in "Restoring" mode
Good afternoon to you all! In SQL Server 2008, I needed to do a database conversion for one of our clients and I was going to do the backup in case there was a problem, only I mistakenly pressed to…
-
0
votes1
answer1051
viewsMysql error - phpmyadmin: Access denied!
I have this problem with phpmyadmin, it was working normal, but when I typed: "mysql" in the linux shell it did not open mysql, only when typing: mysql -h 127.0.0.1 -P 3306 -u root. Then I saw some…
-
0
votes1
answer860
viewsJoin between tables that do not relate directly
I have three tables: Candidate who has an ID as pk (which has been invented) Registration that has FK for Candidate ENEM that has no id representing the candidate, only his registration and…
-
0
votes0
answers109
viewsHow to update a Spinner from Edittext data on Android
I have a Spinner that is being filled with Sqlite data, I want to take this data, edit them and update them My Spinnerdatabase class method (responsible for the Spinner database) public void…
-
0
votes1
answer186
viewsHow do I save an image to the database through an application?
I have an application in c# and I want to make it possible to save a photo in the SQL database. 1- How do I mount the database structure to receive an image? 2- How to send the application photo to…
-
0
votes1
answer315
viewsSee how long it takes for an event to happen - [mysql]
I’m new to mysql and has an event created in mysql database, and I was wondering if you have any way to check how much time is left for that event to run. That is possible?
-
0
votes2
answers426
views -
0
votes1
answer40
viewsProblems to count and group fields in the database
I’m starting to study the SQL language and the interaction between the tables, and I came across an exercise in a list that I’m not able to solve. He asks the following: For each existing product…
-
0
votes0
answers16
viewsStart Determined Online Query in Sql SERVER
SELECT * FROM Customers LIMIT 3,9; I tried that way but it didn’t work
databaseasked 6 years, 3 months ago Evelyn Carvalho 1 -
0
votes0
answers158
viewspersistent python Mysqldb connection
Because I have to keep opening and closing database connection memory consumption goes up? I wonder if I use an open connection always, I will have the advantage of decreasing memory consumption.…