Posts by Geziel • 213 points
7 posts
-
2
votes1
answer534
viewsA: Index for MYSQL - ORDER BY influence when creating an index?
Yes. Notice what the reference manual: If you want to have a higher ORDER BY speed, first you must see if you can make Mysql use indexes... But the practical question is how relevant is this time?…
-
9
votes4
answers1643
viewsA: Is it really necessary to define constraints in the database?
It is not necessary to use them. But if you should, it is a question that depends on each scenario. The role of constraints is to ensure the integrity of the data in the database. The decision…
-
3
votes3
answers1131
viewsA: Open/closed principle - how to understand this?
The beginning open/closed should be applied when the scenario requires there to be assurance that the methods of a child class have not changed and function exactly as originally implemented. In…
-
0
votes2
answers142
viewsA: Date Killing in TXT to compare with Database Date
the problem in this approach is that your user’s regional operating system settings may not match the format of the string you have in TXT. For example: If your date string is: 01-12-2014 (December…
-
1
votes1
answer391
viewsA: What is the weight of a subquery for the query?
Between getting the result through a subquery or performing a second query, the subquery under normal conditions will be less costly because it does not duplicate the execution of the communication…
-
3
votes2
answers46299
viewsA: How can I take the value of a text and print on the screen
Whereas the ID of the textfield element is id1: HTML: <input id="id1" type="text"/> Javascript: //Obtem o valor do elemento textfield e armazena na variável "valor" var valor =…
-
2
votes4
answers2880
viewsA: Is it possible to reference a column that is not a primary key in another table?
Create a unique key (Unique key) in the field id_2 of table 1. This in addition to ensuring the integrity of your key, also allows reference to it.…