Posts by Carlos T. Gomes • 65 points
7 posts
-
0
votes2
answers410
viewsA: How to merge these 2 SELECT into a single query
Speak @Douglas, a possible solution would be by subquery: SELECT DATE(BASE.relManu_data_registro) AS DATA, (SELECT count(MAN.relManu_id) FROM tb_relatorio_manutencao AS MAN WHERE…
-
1
votes1
answer2207
viewsA: Error convert Query SQL Server date and time
You can use CONVERT(DATE, fieldname, 105) since it uses the date in the Italian format dd-mm-yyyy https://www.w3schools.com/sql/func_sqlserver_convert.asp select MesID,Mes,Ano,…
-
-2
votes1
answer128
viewsA: Laravel 5.2 -> 5.6
In the case of layout folder, you can create it manually inside the folder views. However, there are differences between versions that your teacher can demonstrate and in your current version not…
-
-1
votes1
answer35
viewsA: How to use database information from another application?
@Reily, it goes a lot of the negotiation your client/boss had with the owner of this system. Because if there is no conversation before, the owner of SIABI will have no interest in helping to…
databaseanswered Carlos T. Gomes 65 -
0
votes2
answers182
viewsA: Write data to a based table and two other tables
A suggestion would be to use the select into statement. It will automatically create the table after the into You would need to rename existing tables. SELECT colunaA, colunaB, coluna C INTO TabelaB…
sqlanswered Carlos T. Gomes 65 -
0
votes1
answer161
viewsA: Laravel System Deploy in Xampp
Tested like this: <IfModule mod_rewrite.c> <IfModule mod_negotiation.c> Options -MultiViews </IfModule> Options +FollowSymLinks RewriteEngine On RewriteBase /sistemaLaravel…
-
0
votes1
answer520
viewsA: How to Join with Sum and Group By
Fernando, I believe that Join should be done in the Legend field. Date and not in action_plan_detail.Saving_monthly. SELECT date_format(calendar.Data, '%Y-%m') AS Mes,…