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
answer238
viewsHow to display the result of an Inner Join for the user?
I have three tables and want to join them and display them to the user, how can I do this using the functions of Wordpress? INSERTS THE DATA INTO THE DATABASE: function cadastra_experiencia($nome,…
-
0
votes1
answer959
viewsHow to select all columns in the database
How to select all columns in the database with the names 'name' and 'date' I have the code <?php $sql = "??"; if ($rs = $bd->query($sql)) { while ($row = $rs->fetch_assoc()) { echo…
-
0
votes1
answer44
viewsHow to send a Stringbuffer select to a class
I don’t know how to send one select made in my Databasehelper class and send it to a public class, then from that make my code work normally. My Databasehelper class and at the end select: class…
-
0
votes1
answer610
viewsFill FILL-IN with Browser data
I’m trying to create a kind of simple CRUD I got to this point but still have half failed my code, to using the window type Appbuilder I have a screen with "New" "Change" "Delete" "Save" but when I…
-
0
votes1
answer2246
viewsBest Database for Android Application
Guys, I have a question on which bank to choose for an android application: Sql Server or Sqlite? I have a little Crawler, which doesn’t need to run every time, just once, and when there’s some…
-
0
votes2
answers120
viewsInner Join not returning database values
MY BANK CREATE TABLE EXPERIENCIA( exp_pri INT NOT NULL AUTO_INCREMENT, nome VARCHAR(150), email VARCHAR(50), exp VARCHAR(100), PRIMARY KEY(exp_pri) ); CREATE TABLE PRANCHA( prancha_pri INT NOT NULL…
-
0
votes0
answers32
viewsTIME field formatting
I have the following given in the bank 55:42:55 and I need to make it more readable this way 2d7h42m how could I do this formatting?
-
0
votes1
answer66
viewsCreate pagination by displaying current records at the top of the list
I am creating a page that contains paging, but I am with a problem, the paging works perfect but brings the oldest records first and I would like the current records to be displayed first, someone…
-
0
votes2
answers1756
views -
0
votes1
answer444
viewssort the dates in the bank
I’m having the following problem, I can’t sort in ascending order the dates that are saved in the bank, I’m using order by no select but just sort the first two houses until I get to / causing the…
-
0
votes1
answer14
viewsProblem deleting a field from the table
When I try to delete a row from my table, it returns me this error ERROR: update or delete on table "menu" violates foreign key constraint "fk_menu_id" on table "view_menu" DETAIL: Key…
-
0
votes1
answer66
viewsHow to select by the bank the value of the column using the Random() method
I made a project on Android that is a little hangman game, where I can record in the Sqlite database the word and a hint. In my Databasehelper class I created the normal database, and made some…
-
0
votes2
answers60
viewsHow to search the bank with three types of user?
Hello I’m doing a college project, it’s an internship site project, it has to be developed in Java WEB with database. It has three types of user, the student, the company and the administrator. I…
-
0
votes0
answers58
viewsHow to register, query and display data in the same request?
I have a form where the user enters his data (name, experience, height and weight), the information is registered in the database, compared and is returned to the user the ideal board model…
-
0
votes2
answers211
views -
0
votes2
answers922
viewsSecure connection to the database
I was told that this connection mode is not safe, but I did not understand very well why it is not. <?php $conecta = mysql_connect("HOST", "LOGIN", "SENHA") or print (mysql_error()); print…
-
0
votes1
answer992
viewsFilter and pagination
I developed a web page that uses paging and filter, both made in PHP. What makes after using the filter, and select for example page 2, the information will be lost because it will reload all the…
-
0
votes0
answers64
viewserror - SQLSTATE[23000]: Integrity Constraint Violation: 1062 Duplicata du Champ '0' pour la clef 'PRIMARY'
I am working on my tcc in which I create a database of suppliers for a drug company. Summarizing my problem, at the time of sending the data to my database this giving the error message…
-
0
votes0
answers23
viewsPostgresql or Mysql
I am developing a Web ERP System and I need to define the database I will use I believe, I need free database and I am in doubt between Mysql and Postgresql, wanted a feedback from you regarding…
-
0
votes1
answer191
viewsCreate tables in a mysql database hosted at Locaweb
I need to add a table to my database. How do I add a table to this database hosted in Ocaweb? You must have some software or I can upload some file?
-
0
votes0
answers25
viewsMysqli query returns FALSE instead of returning database records
Hello, I’m trying to query the user login data in the php database but I noticed that the variable that receives the function that makes the query always returns empty and I var_dump this variable…
-
0
votes0
answers1569
viewsConsult a record on Sqlite
I’m having a problem to perform a query in a Sqlite database of an android application I’m studying. I can recover all the records that the database contains, but I can’t search a single table…
-
0
votes1
answer672
viewsDatabase - Images
I am very doubtful about a database that stores images and videos... I wonder if there is a database made to store only images, or I can store photos in a normal database? I’m creating a mobile app…
-
0
votes1
answer455
viewsCustomize data from a codeigniter session array
I am trying to create an array with the data I recover from the database, my code is like this $usuario = $this->input->post("usuario"); $senha = $this->input->post("senha");…
-
0
votes0
answers58
viewsHow to create new fields in Wordpress database?
I am developing a system style Infojobs, Catho and CEVIU in Wordpress, based on a Theme already created for this purpose. For a user to register on the site, by default of the theme, he has to…
-
0
votes0
answers50
viewsDelay when executing SQL commands
I have a system where I work with a db online hosted in Justhost.com. I suffer with the delay in executing the commands, but not always these delays exist, sometimes a command takes less than 1s and…
-
0
votes1
answer97
viewsHow to Import Dump with 2 Schemas for Different Dataspaces
I have a Dump with which it was made expdp with 2 schemas. I’d like to do the impdp remapping the tablespace for 2 new tablespaces. Man parfile current: userid=dba/dba@streetfight…
-
0
votes1
answer139
viewsSearch/select database with C#
I have a form with a button and a simple datagridView, but my problem is that I have to search my file in ". mdb" (Access database) on the computer, so it will be shown in the datagridView then the…
-
0
votes0
answers93
viewsWordpress database x memory
I have a news site made in wordpress, hosted in a VPS in godaddy, and due to the large amount of accesses, I’m having problems with hosting, the database falls when we have many accesses and…
-
0
votes2
answers555
viewsSelect in Mysql by skipping simple quotes
Hello How can I use this select and skip value with simple quotation mark? . . .st.executeQuery("select * from tabela_A where id = uc"); rs = st.getResultSet(); while (rs.next()) { texto =…
-
0
votes0
answers36
viewsUndefined index
Hello, I am in a project that works with many forms and I need that when the person arrives in the last form, when clicking on Ubmit it sends the result of a variable javascript to the bank. I’ll…
-
0
votes1
answer24684
viewsSelect in two tables at the same time
I have the author and sentence tables: autor: autor_id | autor_nome 1 | joão 2 | pedro frase: frase_id | frase_frases |autor_id 1 | frase do joão | 1 2 | frase do pedro | 2 3 | frase do pedro | 2 4…
-
0
votes1
answer356
viewsReturn inserted value after INSERT
I have a following table: CREATE TABLE tblUser ( id INTEGER PRIMARY KEY AUTOINCREMENT, uuid VARCHAR(24) NULL, name VARCHAR(256) NULL } I’m inserting a uuid random to be a unique identifier directly…
-
0
votes1
answer655
viewsHow to verify if a Trigger exists or not before creating it?
I intend to create a Trigger in table but first I would like to check if it already exists in my base .... how do I do ? CREATE TRIGGER IF NOT EXISTS before_update_tableX ... ect…
-
0
votes2
answers209
viewsHow to do a recurring auto update correctly?
I am creating a small browser game and recently I came up with a question about how to make a database value be manipulated (consulted/updated) every second, even with the user disconnected. I have…
-
0
votes1
answer275
viewssum specific line in Mysql
Speech person! I am doing the insertion of a time (hour:minutes:seconds) in a column x, I wonder if it is possible to add the current value of the line with the next value that is inserted? like…
-
0
votes1
answer57
viewsProblem with TIMER insertion in Mysql table using JDBC
Personal talk! I have the following problem and I am looking for the best possible solution. The following code when running a time is saved in the tAtual (current time) string and sent to the…
-
0
votes1
answer1825
viewsTrigger to update another table
I have 4 table in my Mysql database. -> companies -> contacts (company addresses) -> bank data (company’s bank data) -> members (members of the company ) All tables relate to the…
-
0
votes1
answer88
viewsHow to do a data migration routine?
Suppose I have a registration model and a user model. How do I get each registration record sent to the users? This should also be done to each new record that is created in the register, it should…
-
0
votes0
answers60
viewsHow to define better names for system entities?
How to define better names for entities in my system. I have a user table. And I have a reset password table where I relate information from the password reset process (id, hash, expiration…
-
0
votes1
answer47
viewsBcrypt - Automating password encryption process
Hello. I already have a column in my database called password. Use Password for authentication, so he created another column called encypted_password. Even if I copy all the password values and play…
-
0
votes1
answer613
viewsCreate a Table at runtime. C#
Hello, I need to create a table within a DB Access at runtime. The Database already exists, I would just like to click on a buttona new tablewas created within this DB with Nome de Campos and Data…
-
0
votes1
answer408
viewsHow to send forms automatically without using Ubmit and without updating the page
Hello, I am a relatively new programmer in php and I am developing a website. It is a site where there is a list of companies. And I wanted to implement in it, search filters, the first of them…
-
0
votes1
answer63
viewsPut WS in Heroku
Does anyone know how to configure persistence.xml to access a Heroku database? I’m trying with the credentials they pass but gives password error to that user. I wonder if someone could help me with…
-
0
votes1
answer600
viewsInsert various data into a mysql column
Good afternoon Guys, I’m cracking my head open about how I make this insert in the bank, it’s kind of like this... I have a product, which needs to be priced more than one supplier, to compare…
-
0
votes0
answers97
viewsClass Tdbtext not found
Good morning, my friends. I am having problems with a program, because every time I start one of the options, it returns me an error of "Class Tdbtext not found', and the package that contains this…
-
0
votes0
answers96
viewsWarning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, Boolean Given in
Good afternoon guys, I’m trying to find out why this mistake... I’m grading all the help you can give me; Warning: mysqli_fetch_array() expects Parameter 1 to be mysqli_result, Boolean Given in C:…
-
0
votes1
answer73
viewsConnection error while performing query
I’m a beginner in programming and I’m trying to connect to a database. But by clicking the "Search" button to browse the database and exbir values on my screen, the following error is generated…
-
0
votes1
answer491
viewsMysql in Java Desktop applications for multiple establishments
Hello, if I make a Java Desktop application with a Mysql database, which will be delivered to several establishments to use, what about the database? Do you have any suggestions? The application, I…
-
0
votes1
answer1682
viewsCan you "hide" the password that goes in mysqli_connect?
$server = exemplo.com; $user = root; $senha = 123; $conexao = msqli_connect($server, $user, $senha); I know the php page is not visible to the user, but nowadays, you cannot underestimate Cracker.…