Posts by Edvaldo Lucena • 135 points
15 posts
-
1
votes4
answers114
viewsA: Doubt QUERY SQL construction
WITH CTE AS ( SELECT TAB1.CODIGO, TAB1.DATA, TAB1.VALOR, TAB2.VALOR, (TAB1.VALOR - TAB2.VALOR) AS DIFERENCA FROM TAB1 INNER JOIN TAB2 ON TAB1.CODIGO =…
-
1
votes1
answer40
viewsA: Reference between two tables by Heidisql
Try it this way: Access the instance your database is in and click on file > New tab for query and type your select . select Tabela.coluna from post inner join usuarios on post.user_id =…
-
0
votes2
answers1019
viewsA: select bringing all un-duplicated records based on a single column
Tried the ROW_NUMBER function ? with CTE_RN as ( select tela, url, perfil, dataCriacao, ROW_NUMBER() OVER(PARTITION BY tela ORDER BY tela DESC) as RN -- Função ROW_NUMBER CRIA UMA NUMERAÇÃO PARA…
-
0
votes2
answers46
viewsA: Insert records that only exist in the source table with MERGE
Thank you ! A colleague in another forum managed to help me. MERGE teste_tb_planos_acoes AS T USING ( SELECT distinct A.designacao, A.Cliente, desc_uds, A.qtde_log, A.rec_ano, O.data_fim, O.dif_dias…
-
0
votes2
answers46
viewsQ: Insert records that only exist in the source table with MERGE
I created the following script that only inserts records that do not exist in the table teste_tb_planos_acoes, put some conditions: If the column value designacao exists in the table…
-
2
votes1
answer38
viewsA: Do Excel formulas continue to work after being imported into a Datagridview?
Mysql cannot "interpret" the formulas made in excel, the solution is: Create a VIEW in Mysql by calculating the dates : timestampdiff(MONTH,SuaColuna,now()) AS TEMPO_DECORRIDO_MINUTOS…
-
0
votes1
answer37
viewsA: CTE: Union of two tables in which one of them has only one field in common
A select with Join, I believe is enough: select Artigos.Referência, Artigos.Quantidade, Artigos.Preço, [Referências Associadas].RefAssociada from Artigos left join [Referências Associadas] on…
-
0
votes0
answers271
viewsQ: Mysql has stopped working
Hello I am using Mariadb 10.2, I executed the TRUNCATE command in a table with 4 GB and Mysql stopped funionar, I can no longer access any other database, I am using Mysql in xampp and it presents…
-
0
votes1
answer110
viewsA: ACCDB + PHP grab column name and table
You need to have microsoft Access installed on your computer to be able to open a file. accdb, so you can see all tables and queries of it.
-
2
votes2
answers2676
viewsQ: Javascript display date of the day before the current
I have following script that works right, but at the turn of the month it does not "mount" correctly the date, for example today, it is showing the date 20181000 var today = new Date(); var dd =…
javascriptasked Edvaldo Lucena 135 -
0
votes2
answers989
viewsA: Pentaho Data-Integration
Here’s a topic that helped me solve the problem: Link
pentaho-kettleanswered Edvaldo Lucena 135 -
-1
votes1
answer117
viewsQ: create Linked in Mysql between different instances
Hello, I have instance A (Local) and another instance B, I need to do a query where I have table A (Local instance) relate to table B of (instance B) is possible ?
-
0
votes1
answer49
viewsQ: Display message as per condition in query
I’m making the difference between dates when the column designacao_circuito are equal and the difference (days) between the dt_hr_fecom is <= 10, I need that in the column Reinc_10_Dias write…
-
1
votes0
answers56
viewsQ: Apache log file
I installed the XAMPP and would like to know how I do to manage the log file of apache (my log file is 50MB and I will have problems in the future). It is possible to delimit a size so that after…
apacheasked Edvaldo Lucena 135 -
0
votes2
answers989
viewsQ: Pentaho Data-Integration
I configured the PDI to access an FTP server and download a file in csv, so that’s okay, the problem is that inside the folder on the FTP server there will always be more file, example:…
pentaho-kettleasked Edvaldo Lucena 135