Skip to content

Instantly share code, notes, and snippets.

@kylejohnson

kylejohnson/gist:4143670

Created November 25, 2012 14:06
Show Gist options
  • Save kylejohnson/4143670 to your computer and use it in GitHub Desktop.
Save kylejohnson/4143670 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
kjohnson@vps:~$ mysql -u house -p house -e 'select SensorName, StatDate, StatValue as Temperature from stats left join sensors on stats.SensorID=sensors.SensorID limit 10'
Enter password:
+---------------+------------+-------------+
| SensorName | StatDate | Temperature |
+---------------+------------+-------------+
| Workshop | 1353440709 | 64.62 |
| Computer Room | 1353440710 | 75.65 |
| Workshop | 1353440929 | 71.15 |
| Computer Room | 1353440931 | 64.51 |
| Kitchen | 1353440932 | 75.54 |
| Workshop | 1353441011 | 71.15 |
| Computer Room | 1353441013 | 64.51 |
| Kitchen | 1353441015 | 75.65 |
| Workshop | 1353441067 | 71.15 |
| Computer Room | 1353441069 | 64.62 |
+---------------+------------+-------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment