Posts by Clayton Tosatti • 1,636 points
68 posts
-
1
votes0
answers209
viewsQ: Estimated run time - Select
I’m performing some performance tests in my BD using Mysql, and I got the following question. Is there any way to predict how long it will take to execute a query in Mysql after starting its…
-
-1
votes2
answers705
viewsA: SQL Error: Can’t reopen table
I do not know if you could meet other situations you have (you would have to know the other tables), but for this case in a very simple way you could use: Select a.oportunidade_id, a.tela,…
-
2
votes1
answer240
viewsA: Moving files in folders
To change the folder name just use the following function: os.rename(old, new) from what I understand Voce wants to number the destination folder, correct? In your case it would be something like:…
-
0
votes1
answer50
viewsQ: Iteration with variable of type 'TIME'
I am doing a project in which I need to perform a loop that increases minute by minute of a variable from two times informed. I thought of logic as follows: vHoraInicial = '13:30' vHoraFinal =…
-
0
votes0
answers20
viewsQ: Working with Shifts in Dimension of Hours
I am structuring a new Datawarehouse that will in the future be consumed on a BI platform. Already created some dimensions for my database one of them was the Dates, in which I break the date into…
-
0
votes1
answer268
viewsA: Get data from a specific column in CSV
Juliana I advise you to use the library Pandas to work with the CSV. In this case Voce could proceed as follows: import pandas as pd After importing the library, Voce must load the file. In the case…
-
1
votes1
answer43
viewsQ: Select on condition
I have the following example table (tbl_Local) in Mysql: ID| LOCAL| COR 1 | A |RED 2 | A |RED 3 | B |RED 4 | B |BLACK 5 | B |WHITE 6 | C |RED 7 | D |BLUE 8 | E |BLUE 9 | E |ORANGE 10| E |YELLOW 11|…
-
0
votes0
answers50
viewsQ: Impact using INDEXES in Mysql
I have a table that currently has 25 million records, due to this any query I do however simple it is becomes very slow. I was researching about INDICES to improve search performance and found that…
-
3
votes2
answers229
viewsA: SQL Maximum value of another table
Raphael the instruction would be the following: Select VehicleID, MAX(LeaseTerms.MaximumKM) from Leases JOIN LeaseTerms on (Leases.TermID = LeaseTerms.termID) GROUP BY VehicleID In this example I…
-
2
votes2
answers860
viewsA: How to create a report in Sql Server with information by date
John by what I understood his instruction should be: Select DataDoPedido, CodProduto, SUM(QuantidadeProduto), SUM(CustoProduto), SUM(VendaProduto) from teste GROUP BY DataDoPedido, CodProduto In…
-
0
votes2
answers2726
viewsA: Recursive function to return string backwards
You are returning this error because the 'word' is a string and not a number to use a comparator as the smallest (<). In this case just add the 'Len' function that will return the string size.…
pythonanswered Clayton Tosatti 1,636 -
1
votes1
answer262
viewsA: Filter VBA function
I have already done this search function but with LOOP using FOR in the Matrix. Just inform the word that should be found and the table in which the search will be performed. Function…
excel-vbaanswered Clayton Tosatti 1,636 -
1
votes2
answers61
viewsA: Python 3 not returning float
On the lines where the 'prints' result simply change the encoding to: print("Media %f"%media) This formatting will allow you to display the content in Float in that link you can also check other…
python-3.xanswered Clayton Tosatti 1,636 -
1
votes2
answers221
viewsA: Turn decimal into Vb minutes
A good solution would be to use the conversion function to INT in its variable. So the difference between the two (Real - Integer) would provide you the number after the comma. Example: Valor_Total…
vb.netanswered Clayton Tosatti 1,636 -
1
votes1
answer1582
viewsA: How popular in database to perform tests?
Good as Voce mentioned Excel. There are websites on the internet that turn CSV files into SQL Scripts ready. Simply Voce inform the file and some parameters it asks for. That one website(Sqlizer)…
-
0
votes1
answer26
viewsA: Get content from email
Hello! I believe this post can help you in this issue friend: Utilization of imaplib (English) As a suggestion I leave the library Imapclient that I find much simpler to work with. Description of…
-
2
votes3
answers3778
viewsA: Count the most popular words
We got two problems there, buddy. Code indentation is wrong on your Return line. It should be referenced to the 1st 'FOR' and not to the IF, so that it can return only after the complete completion…
-
4
votes2
answers131
viewsA: What does the expression !(...) mean?
Anything you put inside an if("Anything") will be turned into true or false. The if body only executes if the result is true. In your case as there is the character '!' indicates a negation of IF,…