minkymorgan

## shell commands I used to setup mysql on my raspberryPI and enable SQLyog access to it from my laptop

# install mysql using these instructions
# http://databaseblog.myname.nl/2013/01/how-to-install-mysql-succesfully-on.html

# Verify the MySQL Client was installed

mysql --version

# alter the settings to enable it to be a server on your lan

minkymorgan

NR == 1 {sep=""}
NR > 2 {sep=","}
{
        if (NR == 1) {
                split($0, tags);
                if (EC == "") EC = "\"";
        }
        else {
                split($0, vals);
                jrec = sep"{";

minkymorgan

select 
end_SQLDATE           as SQLDATE
, AVG_GoldsteinScale
from
(
SELECT 
	  ending_at_day    AS end_SQLDATE
, 	ROUND(AVG(SUMG),5) AS AVG_GoldsteinScale
,	  COUNT(DISTINCT SQLDATE) as C
FROM