mysql -h irtfweb -u cshell -p
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2009449
Server version: 5.1.73 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cshell             |
| test               |
| test_dewar         |
+--------------------+
4 rows in set (0.01 sec)


mysql> use cshell;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+------------------+
| Tables_in_cshell |
+------------------+
| Data             |
| Sensors          |
+------------------+
2 rows in set (0.00 sec)

mysql> SELECT * FROM Sensors;
+-----------+-----------------------------------+
| SensorID  | Notes                             |
+-----------+-----------------------------------+
| tca_t1    | TcA temperature 1, kelvin         |
| tca_t2    | TcA temperature 2, kelvin         |
| tca_setpt | TcA set point, kelvin             |
| tca_heat  | TcA heater output, 0-100, percent |
| tca_p     | TcA P value                       |
| tca_i     | TcA I value                       |
| tca_d     | TcA D value                       |
| tcb_t1    | TcB temperature 1, kelvin         |
| tcb_t2    | TcB temperature 2, kelvin         |
| tcb_setpt | TcB set point, kelvin             |
| tcb_heat  | TcB heater output, 0-100, percent |
| tcb_p     | TcB P value                       |
| tcb_i     | TcB I value                       |
| tcb_d     | TcB D value                       |
+-----------+-----------------------------------+
14 rows in set (0.00 sec)


(Here is a complex example, we will query for the tca_ data, from a specific time, the data
is grouped and order by timestamp.)


mysql>  SELECT Timestamp, FROM_UNIXTIME(Timestamp) AS Date, GROUP_CONCAT(SensorData ORDER BY SensorID SEPARATOR ' ') AS SensorData 
     FROM Data 
     WHERE (Timestamp > UNIX_TIMESTAMP('2014-11-21 10:30:00'))  AND  (Timestamp < UNIX_TIMESTAMP('2014-11-21 12:30:00'))  
     AND SensorID LIKE 'tca_%' 
     GROUP by Timestamp;


+------------+---------------------+-------------------------+
| Timestamp  | Date                | SensorData              |
+------------+---------------------+-------------------------+
| 1416603924 | 2014-11-21 11:05:24 | 101 21 151 501 30 30 59 |
| 1416603945 | 2014-11-21 11:05:45 | 101 20 151 501 30 30 60 |
| 1416604003 | 2014-11-21 11:06:43 | 101 20 151 501 30 29 61 |
| 1416604061 | 2014-11-21 11:07:41 | 101 19 151 501 30 30 60 |
| 1416604119 | 2014-11-21 11:08:39 | 101 19 151 501 30 30 58 |
| 1416604178 | 2014-11-21 11:09:38 | 101 19 151 501 30 29 60 |
| 1416604236 | 2014-11-21 11:10:36 | 101 20 151 501 30 29 58 |
+------------+---------------------+-------------------------+

mysql> exit