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
votes3
answers122
viewsGet the record name in the most repeating column
I need to display the record that repeats most in the column tipo_doenca from the column localidade, that is to exhibit the disease that is in the largest quantity in that locality. Table name:…
-
-1
votes1
answer30
viewsHow to collect the running time of activities performed in the database without running directly in mysql
I need to get the runtime of several Serts , updates , alter Tables among other activity that I do in the bank , I know that if I did it directly in mysql it would return me at the end of the…
-
-1
votes1
answer331
viewsSybase database connection with c#
I have a Sybase database file on my machine, I want to make this database available in my application c#, how I make this Sybase database file available, and how to access this database with c#?…
-
-1
votes1
answer344
viewsAlternative to Phpmyadmin
Can anyone tell me a database manager where I can build more complex queries without having to enter the query? Just clicking where I want to make a SELECT for example? I need to do several queries…
-
-1
votes2
answers928
views -
-1
votes1
answer345
viewsHow to enter the generated id in the Insert as a foreign key from another table?
<?php include_once "./Models/Usuario.php"; include_once './Models/Login.php'; include_once './Models/Profissional.php'; include_once './Models/Cabecalho.php'; include_once './Models/Teste.php';…
-
-1
votes1
answer50
viewsCatch id auto increment of two joined tables (INNER JOIN)
Let’s see if I can explain at first... have two tables [topics] and [notification] I joined these tables with INNER JOIN to get the data of both, so far so good... but when I need to select the [id]…
-
-1
votes1
answer35
viewsHow to put zeros after type checker - sql server
I need to put 9 zeros after 02: 0207200000053P 02- here comes the zeroes - 07200000053P that is coming from a variable called @vNossoNumero. How do I do that? Variable Select @vNossoNumero = case…
-
-1
votes4
answers126
viewsCan I put a WHERE for each column?
I’m willing to put a condition for each column in my SELECT, this is possible? SELECT count(id_casa) as casaAzul, count(id_casa) as casaAmarela FROM tb_casa Where: Where column 1: Where cor_casa =…
-
-1
votes1
answer72
viewsError connecting to database
I try to make the connection in my comic, but keeps giving the error "Failed to connect!" The data in my comic book is: Data Base: a test Table: customers trying to connect by PHP <?php $conn =…
-
-1
votes1
answer39
viewsProcedures Mysql
Hi, I’m new to procedures and I have a question I couldn’t find on the internet. I need to create a procedure to include 2 tables: "User", "Supplier". The provider has a user FK, that is, in this…
-
-1
votes2
answers68
viewsdatabase saving only password
This is my first post here, I’ve been following the forum for a long time but I never wanted to interact, today this desire arose along with a little problem ... I’m learning to html, css, php and…
-
-1
votes1
answer380
viewsDatabase Modeling (Entity Relationship Model)
In the image below is the modeling of the following problem. I have users where these will belong to modules(Physical module, Portuguese module, chemical module) are 3 modules in total.One and only…
-
-1
votes2
answers2780
viewsReturn PHP values via Ajax and display in HTML (separately)
Can you return values from a PHP page via Ajax and display them separately? Ex. I have a PHP page on which I have the return values: <?php echo $a; echo $b; echo $c; ?> Currently I can…
-
-1
votes1
answer54
viewsChange multiple identical words in Oracle query
I am having to deal with a very large amount of equal words in my Oracle query and having to change one by one each of them each time I have to test the query with a different field is being…
-
-1
votes2
answers523
viewsA phone chart for each customer or just one for all customers?
Currently in college we learn like this: It has a client entity, this client has its attributes and one of them is the phone, I want it to be possible to register several phones, we create a single…
-
-1
votes1
answer24
viewsDo you know of any unique Postgresql features?
I wanted to know if there is any function or feature exclusive to Postgresql, something that does not have in the other DBMS’s.
-
-1
votes1
answer172
viewsCheck if the completed email already exists in the PHP database
Not being able to register or check the emails, be able to help....…
-
-1
votes1
answer25
viewsphp database
someone can help me,....…
-
-1
votes1
answer48
viewsHow to bring a bank query according to a select, for an input
I want to put a value of the bank when selecting the vehicle, until I was able to put any value, but I can not search the bank via AJAX or JSON…
-
-1
votes1
answer56
viewsRelationships of Tables and Databases
It’s a simple question, which is restriction of integrity of relationships. Please help me, I have a TCC in a week and I haven’t finished this thing yet :'(
-
-1
votes1
answer5130
viewsmysqli_real_connect():(HY000/2002):
I have a problem accessing my phpMyAdmin. I started using Wampserver to program in PHP. I don’t know if I should make some initial configuration, but the way I tried to log in was without filling in…
-
-1
votes1
answer715
viewsAccentuation of indigenous names in the Oracle database
We have a situation of inclusion of records of indigenous names in the Oracle bank, where there is a variation of accentuation, and may have "e" or "u" with tilde. Our Oracle parameters (version 9i)…
database oracle character-encoding accentuation unicodeasked 5 years, 6 months ago Mauricio Adriano 21 -
-1
votes1
answer146
viewsError when changing the data type of a column by the interface
I try to change the type of data VARCHAR for another type of data by the system interface (I don’t want to change via SQL) but I can’t. I have the following table created: CREATE TABLE `Usuarios` (…
-
-1
votes1
answer37
viewsHow do I create a view in mysql by taking data from 2 or more different tables?
To Starting to see View in database now, more has arisen a doubt in this exercise, I have to view items from 3 different tables but do not know how.…
-
-1
votes1
answer185
viewsHow do I update a Jlabel?
I need to update a Jlabel every time I press a particular button that searches for a database form to generate a chart, but it only works the first time. My idea was this: if Jlabel is empty it adds…
-
-1
votes1
answer528
viewsHow to locally save data returned from an API to a JSON file?
I’m making a requisition HTTP to receive data, after receiving it, I need to store it locally in a file JSON. How can I create and transfer this data to the archive .json? Requisition HTTP : const…
-
-1
votes1
answer380
viewsHow do I enable Postgresql in Cpanel?
Good afternoon. I would like to know how to activate Postgres in the Cpanel menu of the database part, I need to create a database in Pg. I have already done the installation in WHM and enabled the…
-
-1
votes3
answers37
viewsList of vehicles that are without photos
I need the list of vehicles that do not have registered photos. I have a Vehicles table, an Image table and another Type. Example: tbVeiculo (VeiculoId, DataCadastro, Etc...) tbImagemVeiculo…
-
-1
votes1
answer42
viewsinsert xml record plus date into a time table
I wanted to make this select but I can’t > DECLARE @XML XML > SET @XML = > '<rows> <row> <tracking> JU148345357BR</tracking> </row> <row>…
-
-1
votes1
answer441
viewsSynchronize an automated Dataset
Good morning! I’m creating a sicronized dataset inside a Totvs system called Fluig, I can get that dataset to search my database and return the information quietly, but when I put for it to do this…
-
-1
votes1
answer223
viewsLIMIT TO TWO OUTPUT CHARACTERS WITH REGEX - POSTGRESQL
I have the query below that returns me only the numerical values of my string field, I wanted to limit it to two output characters. QUERY SELECT NULLIF(regexp_replace(temperature, '\D','','g'),…
-
-1
votes1
answer216
viewsImport CSV into SQL Server
I tried to import a database using csv to a ready-made sql server base that we have deployed to other companies. But in the system when registering, a client for example, uses MAX(ID)+1 to generate…
-
-1
votes1
answer25
viewsHow to convert a Mysql view to Postgresql?
I’m making a migration from a Mysql database to Postgresql, but my view is not being accepted, I’ve been all over the internet looking for a way to modify it no longer worked, someone knows how it…
-
-1
votes1
answer54
viewsUpdate json object in a varchar column
Guys I’m having a problem at Postgres, I have a column that’s in format varchar but as a need I have to put a saved JSON object in it {"value": "value", "value2": "value2"} It is possible to update…
-
-1
votes1
answer27
viewsProblems with the database
Well guys I created an account in aws, to manage it with mysql I wrote the password the user and I’m sure that this disgrace does not log, already Mechi in ec2, I put to be accessed by any ip with…
-
-1
votes1
answer160
viewsCompare duplicate records in the database with PHP and Mysql
I am trying to make a condition that prevents you from saving the same login name of another already registered user. $login_fail=("SELECT DISTINCT $login FROM login"); if(empty($nome)){ $errMSG =…
-
-1
votes1
answer22
viewsConvert query to RAW query
What this query looks like in Mysql RAW format? $user = User::query() ->where(static function ($query) use ($indicador) { $query->where('indicador_id', $indicador) ->orWhere('level_ref',…
-
-1
votes1
answer75
viewsintegrating php with mongoDB DB
I’m running a test to save the site information in the database and the code I wrote to see if the PHP and the bank are connected was that: <?php $mng = new…
-
-1
votes1
answer76
viewsSQL queries of state names with their number of cities
Good evening, I am starting to study SQL and I am making small queries in the database to practice. But I fall for the one that asks to display the names of the states with the respective number of…
-
-1
votes1
answer122
viewsHow to use Mongodb 'Regex' filter in PHP
I have made some attempts following examples on the internet, I found some until there seems to be a mix of the two versions of the driver Currently, in the Mongodb bank I have a structure similar…
-
-1
votes1
answer560
viewsView data via ajax/jquery from the database
I need to display the data related to users who are in a table in the database, but this data does not receive an input (input in the login form), are not filled. I just want to select the values,…
-
-1
votes2
answers52
viewsFor better performance in the Postgresql database is it better to have the products divided into smaller tables?
Hello, I’m developing a system to manage the sale of several real estate developments. In this system each enterprise has a group of units available, type "Apartment 21 - 2nd Floor, Apartment 34 -…
-
-1
votes1
answer95
viewsGenerate a set of numbers in php
Friends need to automatically generate a sequence of numbers and comma separations in php, for example. 1,2,3,4,5,6,7,8,9,10,11,12 save in a variable and then make an Insert in a mysql database.…
-
-1
votes1
answer471
viewsProblems connecting Node.JS Express in Mysql
I know my project is correct that there is nothing wrong, I think the problem is my newly installed bank, how can I solve this problem? Unhandled rejection SequelizeConnectionError: Client does not…
-
-1
votes1
answer21
viewsMake a relationship with data already created
I’m working on a school registration system with Alavel. It currently has two tables in the database: the list of Classes and the list of Teachers. When registering a new class, I want to be able to…
-
-1
votes3
answers54
viewsProblem when consulting the registered position where it shows null value
Hello I am new in programming but I am developing a code through the advanced Java course of Bradesco site and there the last part is to assemble a system, however I have a problem in the…
-
-1
votes1
answer33
viewsWhat alternative do I use to solve the problem of the get() function not working
from tkinter import * def executar(): l1['text'] = t1.get() l2['text'] = t2.get() l3['text'] = t3.get() root = Tk() root.title('App') t1 = Entry(root) t2 = Entry(root) t3 = Entry(root) l1 =…
-
-1
votes1
answer75
viewsHow many tables will you need in Mysql?
I’m starting a project that aims to manage students' grades and subjects. The information I’ll need to store is: Total subjects (All subjects the student will need to study) Current materials (These…
-
-1
votes2
answers70
viewsWhat’s the fastest way?
I made a little game in Java and the players' dice are in the database, when a player enters, he is placed in a ArrayList<PlayerData> where it contains the getters and setters of level, money…