banco-de-dados

I am creating a program in which the user will put the login and password before entering the system,and after he puts his in ... this program that generates the hash in Java and will be used in html, to then be saved in the database. How can I do this ?

I am creating a system for selling products and I need that these products can have different prices according to their size ... el I created would this be possible? Follows the model: If anyone wants to import the template into your MySQL Workbench.

Has how to convert dates in varchar to date. I am having difficulty performing searches between dates, due to this discrepa ... and dt_item between '15/05/2017' and '31/05/2017'; The result of my search returns me values of dates before my range.

I know what a tuple is in Python but not in database, so follows the Question: What is a Tuple in the database context?

What does connection pool mean when it comes to database? What does this concept imply in practice? What is its usefulness an ... database maintained so that connections can be reused when future database requests are Required Source : Wikipedia

I'm not talking about web implementation indicator . Besides the acronym, why is it important?

A times I have been following questions that involve the term procedure in database, so the doubts: what is procedure? where to use it, what is it for? If possible examples of use clarify the layman's mind (mine).

I can't display the photos I'm sending to the database. I am making a comment system with photo and I managed to send them to ... href='Sistema_comentarios.php'>Voltar</a></p>"; ?> </div> </body> </html>

I am developing an App using Phonegap / Cordova and Sqlite, but along with the app it is necessary to go a database containin ... the "Buld" it stays in the App. It's been 2 weeks since I've been able to find this information, can anyone give me a light?

I was chatting with some programmer friends when I heard the term "database normalization". Although I have heard this term a ... rm or can it be spoken in both ways? I no longer want to be ashamed to hear such a term in a meeting and be misunderstood :)

What is the difference between using the data types varchar and nvarchar? nvarchar exists in every SQL database? is ther ... is there a criterion for using them? And I saw that there is also the same with char and nchar. Does the same apply to them?

I need help with an issue involving allowing objects in the database. I have the following scenario: 1 database 4 diff ... s proposed here do not apply to my case... nor here... from what I researched my problem fits into ownership chains break

Lately I have been studying the graph-based database Neo4j. Considering that the vast majority of current applications use t ... be the main pros and cons? in the National (Brazilian) scenario, there is adherence of this type of database in production?

I am working with PHP and have about 8000 records currently in DB. As it is for a web page, I need to do a pagination to mak ... usuario.idCliente from usuario where usuario.login = 'julio') order by dataHora desc GIST How to proceed in this case?

DISTINCT The select DISTINCT statement is used to return only values different (different). Within a table, a co ... seem silly, but these types of statements confuse people and although they do not seem, the use of both bring equal results.

I need to create a stored procedure to insert a game into my database. A game relates to a championship through Table campeon ... I would get the codJogo which is primary key identity of my insert and so inserting into campeonatoJogo. Thank you right now.

A Simple key is associated with a single value, or field, in the record. A compound key corresponds to the combination o ... ple. In what situations is it recommended to use the composite primary key? And when it is better to use simple primary key?

In a Transact-SQL book (Ramalho series) it is said: CAST AND CONVERT Implicitly converts one expression of data types to a ... is a synonym for CONVERT? What is the use orientation of one and the other? Is there a performance implication between both?

At the conceptual design level we can use the approach (relationship entity modeling (MER)) to describe the behavior of futur ... I just read the Chapter 7 Source: database systems 6th edition, authors: Elmasri, Ramez Navathe, Shamkant B. Year: 2011

According to Oracle documentation, a Materialized View is a database object that contains the results of a query and a View i ... what really is the difference between the two? There are difference between performance and procedural costs of the database?