I am trying to use MySQL/php after using MS Access in Frontpage.
I have a query that will not work in MySQL. Is there a way to validate MySQL queries?
SELECT [000_skaters].Player, First([000_skaters].POS) AS FirstOfPOS, Count([000_skaters].SN) AS CountOfSN, Sum([000_skaters].GMS) AS SumOfGMS, Sum([000_skaters].GLS) AS SumOfGLS, Sum([000_skaters].AST) AS SumOfAST, Sum([000_skaters].GLS)+Sum([000_skaters].AST) AS PTS, IIf(Sum([000_skaters].GLS)+Sum([000_skaters].AST)+Sum([000_skaters].GMS)=0, 0, (Sum([000_skaters].GLS)+Sum([000_skaters].AST))/Sum([000_skaters].GMS)) AS PPGM, Sum([000_skaters].PPG) AS SumOfPPG, Sum([000_skaters].PPA) AS SumOfPPA, Sum([000_skaters].SHG) AS SumOfSHG, Sum([000_skaters].SHA) AS SumOfSHA, Sum([000_skaters].PPG)+Sum([000_skaters].PPA)+Sum([000_skaters].SHG)+Sum([000_skaters].SHA) AS ESP, Sum([000_skaters].PM) AS SumOfPM, Sum([000_skaters].PIM) AS SumOfPIM FROM 000_skaters GROUP BY [000_skaters].Player, [000_skaters].TM HAVING ((([000_skaters].TM)='teamA')) ORDER BY Sum([000_skaters].GLS)+SUM([000_skaters].AST) DESC, Sum([000_skaters].GMS) DESC, [000_skaters].Player ASC
I have a query that will not work in MySQL. Is there a way to validate MySQL queries?
SELECT [000_skaters].Player, First([000_skaters].POS) AS FirstOfPOS, Count([000_skaters].SN) AS CountOfSN, Sum([000_skaters].GMS) AS SumOfGMS, Sum([000_skaters].GLS) AS SumOfGLS, Sum([000_skaters].AST) AS SumOfAST, Sum([000_skaters].GLS)+Sum([000_skaters].AST) AS PTS, IIf(Sum([000_skaters].GLS)+Sum([000_skaters].AST)+Sum([000_skaters].GMS)=0, 0, (Sum([000_skaters].GLS)+Sum([000_skaters].AST))/Sum([000_skaters].GMS)) AS PPGM, Sum([000_skaters].PPG) AS SumOfPPG, Sum([000_skaters].PPA) AS SumOfPPA, Sum([000_skaters].SHG) AS SumOfSHG, Sum([000_skaters].SHA) AS SumOfSHA, Sum([000_skaters].PPG)+Sum([000_skaters].PPA)+Sum([000_skaters].SHG)+Sum([000_skaters].SHA) AS ESP, Sum([000_skaters].PM) AS SumOfPM, Sum([000_skaters].PIM) AS SumOfPIM FROM 000_skaters GROUP BY [000_skaters].Player, [000_skaters].TM HAVING ((([000_skaters].TM)='teamA')) ORDER BY Sum([000_skaters].GLS)+SUM([000_skaters].AST) DESC, Sum([000_skaters].GMS) DESC, [000_skaters].Player ASC