Posts by André Luiz Bittencourt • 38 points
4 posts
-
1
votes1
answer33
viewsQ: Efficiency in querys with different schemas [Mysql]
Is there any loss of efficiency making querys in different schemas? For example query 1 is more efficient than query 2? 1: SELECT * FROM SC1.T1 INNER JOIN SC1.T2 ON ... 2: SELECT * FROM SC1.T1 INNER…
-
0
votes0
answers57
viewsQ: Testing mysql API and nodejs integration
I have an API written in Nodejs (express) that uses the library mysql to pull data from a database hosted on AWS. API endpoints are basically SQL queries, almost without logic associated with data…
-
1
votes1
answer111
viewsA: Comparison of equal elements and exclusion C++
You can use a set to go storing node values and if Voce finds a value that already exists in this set you can delete the node. Remember to add the library #include <set> void…
-
0
votes0
answers42
viewsQ: Insert primary and foreign key at "same time" SQL
Suppose two tables "company" and "employee" within employee has a key Foreign for the company When the user goes to create a new company he answers a form that in this form he adds the name of the…