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
answer280
viewsStrange characters saved in MYSQL
My system is powered by an XML file every day. When saving to the database, Mysql saves one way and when rescuing this data using PHP it is displaying on the page as follows: Being that in these…
-
0
votes2
answers838
viewsPass txt database to mysql
Hello, I’m with a txt file where I wanted to get its contents to put in a database, but I’m having difficulties following an example of how this file: [03471] Nome=fulano Idade=20 Sexo=Masculino…
-
0
votes0
answers227
viewsUpdate photos in php database
Good afternoon, I’m having a problem saving the image in the database. It turns out that the image I update goes to the folder where it should, but in the database neither saves her name nor the…
-
0
votes0
answers31
viewsRegistration (Log) of visits to a Website through IP and secure in a BD
After a survey I still haven’t found what I wanted. I wonder if you can help me in the reasoning for this feature. With PHP and Mysql it is possible to save visits to a Website in a database, and in…
-
0
votes1
answer170
viewsVery slow SQL query in Openedge database, what can it be?
I’m having trouble executing queries in the Openedge 11.6 database. Several queries take a long time to be executed, sometimes almost 2 minutes. Here’s an example of a query I’m trying to run:…
-
0
votes2
answers443
viewsHow do I take data from an Entry and add it to the Database (sqlite3)
from tkinter import * jan = Tk() jan.title("Dados") jan.geometry("200x200+250+100") label = Label(jan, text="Nome:") label.grid(row=0, column=0) nome = Entry(jan, width=25) nome.grid(row=0,column=1)…
-
0
votes2
answers917
viewsHow to reduce the running time of a query in SQL server?
I have a query that when it runs it’s taking a little while to bring results. And I don’t know where to start to improve this query. If anyone can help me I’ll be grateful. The query copies record…
-
0
votes1
answer295
viewsProblems connecting Postgres with java
Well, I’m having a problem connecting my java application to my database (I’m using pgAdmin4 which is basically postgres). Java code: public class ConnectionFactory { private static final String…
-
0
votes1
answer146
viewsI can create a table in mysql that shows the person’s age by subtracting today’s year - her birth year?
Question: I can create a table in mysql that shows the person’s age by subtracting today’s year minus her birth year? create table idade2 (ID auto_increment Primary key, data_nasc date, idade int as…
-
0
votes1
answer683
viewsBetter understanding max_user_connections count in Mysql
If on a page I have connection and query to more than one database will count as two connections And if it is the same database but has multiple queries (select) it will count as several active…
-
0
votes1
answer117
viewsArray saving data in the database with a field written array
I have two fields saved in the database (in this case it would be as a comment on the request in the Brazilian language, but that doesn’t matter much). These fields are being saved correctly, but…
-
0
votes2
answers190
viewsProblems with accentuation
I have visited several sites and Stackoverflow was the main one, where several solutions were proposed to problems of accentuation in the pages. I realized that I had set up my database wrong…
-
0
votes1
answer84
viewsPrint table value
I have a login system, which each user is redirected to a specific page. In my database table I have the columns name, user, password and level. I would like when the user logged in, the registered…
-
0
votes0
answers382
viewsCarousel bringing a table with database information
is the following I wanted to know if it is possible to put a table inside the Carousel, bringing the data of 5 in 5 lines, when it completes 5 lines the next data would continue in the next page,…
-
0
votes1
answer85
viewshow to change a column and primary key to Identity?
Well I made a table in sqlserver and put the primary key as normal int but I need to change it to Identity. how do I??
-
0
votes1
answer136
viewserror in the path to bank connection
I’m trying to add this path to the connection to the bank, and it gives me this error: File "C:/Users/gabri/PycharmProjects/allbd_s/conc.py", line 4 path='C:\Usuario\gabri\SQLite\conx' ^…
-
0
votes1
answer649
viewsTo change the column name of a table using the Add-Migration Code First Asp.Net MVC command
I have a table already created and I want to change the column name without them being deleted, because it already has a lot of information. I did the procedure of renaming the property Street to…
-
0
votes1
answer47
viewsHow can I not let you register any foreign key?
I have a database of an electronic urn with the following tables: Voter(Pk title ) Votoscomputers(Fk quibbler , vote) To my knowledge, the table VotosComputados should not insert a FK any, and yes…
-
0
votes0
answers44
viewsSite integration with Excel spreadsheet
Hello, I wonder if it is possible to use an excel sheet already configured with formulas and records as a "database" of a website. The intention is for the person to access the page, enter the data…
-
0
votes1
answer99
viewsEntity database modeling for history
In the system I am developing there are several parts that will need data history. As I did so far it was, for when you need a history for a table I created another table with the same fields and…
-
0
votes1
answer67
viewsRelationship in tables in the database
I have a table in the database called Veiculo and it has the following fields: placa, renavam, marca, cor and categoria. To the placa and renavam is all right, since the data are unique. My question…
-
0
votes0
answers51
viewsColumns of sql server tables are not recognized in php
I have columns that were saved in sql server with uppercase letter, when I receive in php I needed him to recognize them both minuscules and uppercase. For example: select * from rzv_aluno records:…
-
0
votes1
answer71
viewsPage for each user created in the database
My question quickly explained: I have a database with 20 registered users. Each user’s page layout is already defined. Each user can change only their name, place their photo in an already defined…
-
0
votes0
answers139
viewsHow do I validate insertion on android?
Code: package com.example.scrumfacil; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper;…
databaseasked 7 years ago Leanderson Oliveira 11 -
0
votes2
answers259
viewsSingle auto increment on all DB tables
Hello, my DB has several tables that have the same column: `PROD` int(11) NOT NULL AUTO_INCREMENT This column is an identifier that makes one that makes an increment with each launch. The issue is…
-
0
votes1
answer30
views -
0
votes1
answer45
viewsRemove Group_concat and list each one separately
I want to remove group_concat to list each one separately, some hint? SELECT U.login, (SELECT Group_concat(AC.curso ORDER BY id ASC) FROM alunos_cursos AC LEFT JOIN cursos C ON AC.curso = C.id WHERE…
-
0
votes1
answer27
viewshow to upload a file and download it via php?
I created a button to make the ulpoad of a file for the database. up to there beauty. but there is a problem it saves the file with the day and time instead of the file name. I wanted to know if…
-
0
votes1
answer200
viewsError executing mysqli_query() in BD Select
When I will register something in the database of this PHP code <?php session_start(); include_once("../seguranca.php"); include_once("../conexao.php"); $nome_nivel = $_POST["nome_nivel"]; $query…
-
0
votes0
answers594
viewsHow to change Mysql to Mysqli
Well, half of my project is using mysql plus I added a new function that uses mysqli which is generating some conflicts in the database. Either it saves what is in mysql or what is in mysqli. I…
-
0
votes1
answer352
viewsFirebase with Javascript - Get the Child title from the database
Good people, I need to capture with javascript the name of Childs 10th of 2017 and 11de2017 from the following image database: Initially I tried as follows: var datasWO =…
-
0
votes2
answers49
viewsDoes table order make a difference in modeling?
I am building a database with the following tables: Aluno: id_aluno, aluno_login, aluno_senha, aluno_nome, aluno_sobrenome, aluno_cidade Aluno_Categoria: id_categoria_curso, id_categoria, id_aluno…
-
0
votes2
answers218
viewsInsert data into the database with php
I’m trying to insert some data into the database via php, but it can’t add this data, would anyone know what it might be? I give a var_dump in the array to see if it is pulling the data correctly…
-
0
votes1
answer45
viewsselect picking up the items that are in the current day and time
I want to take items that are less than the current date and time, but when I run select from the error message, not a Valid Month. In the database the date is set as follows, '25/09/18 10:23'.…
-
0
votes1
answer47
viewsDatabase , event or routine ? would work?
I am new to create event and routines in the database and I came up with a question I am making a payment system and I wanted to know if it is possible to put this function as an event or a routine…
databaseasked 6 years ago Cyber Hacker 469 -
0
votes1
answer568
viewsConvert entire mysql database to lowercase
It is possible convert all columns of tables in a database mysql for lower-case letters? I have several records and several tables, all are a patchwork of upper and lower case (and some with…
-
0
votes1
answer124
viewsSQL Server vs Mongodb - Disk Size
Today I have a table in SQL Server very large and receives data all the time referring to some factory machine. This is causing a problem of large disk consumption, table size keeps increasing. If I…
-
0
votes1
answer36
viewsHow to update a column once per page viewed?
I’m trying to create a hit counter, this code updates my column 1 time per session, but what I want is to update my column whenever the user views a new page. if(!isset($_SESSION))session_start();…
-
0
votes1
answer68
viewsIs it possible to say that the scheme is normalized in 3FN?
Explaining the Context In the internet found an example of a scheme described in this way: account(num-conta, descr-conta, launching(num-lanc, tipolanc, data-lanc, valor-lanc)). Notice that the way…
database modeling relational-model relationship normalizationasked 6 years, 11 months ago Jonathas B. C. 883 -
0
votes0
answers121
viewsConversion from Date ("yyyy/mm/dd") to ("dd/mm/yyyy")
I’m using a field of sorts Date in the archive HTML, to facilitate the selection of the date, but it will be saved to the bank in American format yyyy/mm/dd, I did the following query to transform…
-
0
votes1
answer529
viewsSend a Servlet object array to a jsp page
I need some help I have a Servlet that returns an array object p with a select query. I would like to know how to display this object in my jsp in HTML input fields (text box)
-
0
votes1
answer182
viewsLimit amount of SQL information
How can I limit the number of rows in my SQL table?(other than with limit in select, it’s not like query) ex. I have to have a maximum of 10 information in the table, but it is not limited, if 30…
-
0
votes0
answers35
viewsInsert data into a table from another 4
I have this code to enter data into the database, I would like to insert data from 4 tables into one. But consecutively, I tried this way only that it adds the same data to the last 3 tables and…
-
0
votes1
answer49
viewsData manipulation in the programming or database
Assuming I need to handle a given example I get weight and height from a user. I want to calculate her BMI to enter into the database. This BMI calculation must be done in a function in the code, or…
-
0
votes1
answer29
viewsError saving data to Database
import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper;…
-
0
votes1
answer842
viewsMysql - How to make a Stored Process be activated once a day?
I need a Stored Procedure to be called every day at 11:59 pm but I’ve tried a few ways and when it arrives at that time it doesn’t perform! CREATE EVENT `ATUALIZARDADOS` ON SCHEDULE EVERY 1 DAY…
-
0
votes2
answers168
viewsSecurity failure (PHP, JS, API, MYSQL)
I made a site with login, registration and etc. I validated the login and registration with POST method, the site is on the server and everything, but when I put the link of the url already inside…
-
0
votes1
answer51
viewsGet sql that triggers a Trigger before update
I have a Trigger before update very simple, I would like to take the sql that fires that Trigger. CREATE OR REPLACE TRIGGER atualiza_subelemento BEFORE UPDATE ON tb_material FOR EACH ROW BEGIN IF…
-
0
votes3
answers437
viewsVisual Studio INSERT command error
I have a web application in visual studio where I am getting the following message whenever I try to give an Insert command System.Data.Sqlclient.Sqlexception: 'An Explicit value for the Identity…
-
0
votes0
answers137
viewsAndroid Studio Database Connection using JSON
I am with the following problem, I am making an app q contains login and user registration and I am using PHP and JSON code for this. However I checked my Response.Listener is never called, the…