mysql -h irtfweb -u spex -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 66887
Server version: 4.1.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+-------------+
| Database |
+-------------+
| autofocus |
| mysql |
| nsf2butemps |
| nsf2temps |
| spex |
| test |
| tiki-1 |
| troublelog |
| upload |
| vehicle |
| wikidb |
+-------------+
11 rows in set (0.01 sec)
mysql> use spex;
Database changed
mysql> show tables;
+----------------+
| Tables_in_spex |
+----------------+
| Data |
| Sensors |
+----------------+
2 rows in set (0.00 sec)
mysql> SELECT Timestamp, FROM_UNIXTIME(Timestamp) AS Date, GROUP_CONCAT(SensorData ORDER BY SensorID SEPARATOR ' ') AS SensorData
-> FROM Data
-> WHERE (Timestamp > UNIX_TIMESTAMP('2009-11-06 00:00:00')) AND (Timestamp < UNIX_TIMESTAMP('2009-11-06 01:00:00'))
-> AND SensorID LIKE 'spex%'
-> GROUP BY Timestamp;
+------------+---------------------+---------------------------------+
| Timestamp | Date | SensorData |
+------------+---------------------+---------------------------------+
| 1257501627 | 2009-11-06 00:00:27 | 109 117 122 138 145 152 161 175 |
| 1257501688 | 2009-11-06 00:01:28 | 105 117 120 139 147 152 169 176 |
| 1257501748 | 2009-11-06 00:02:28 | 103 113 124 134 149 150 164 178 |
| 1257501808 | 2009-11-06 00:03:28 | 100 115 123 131 147 154 164 178 |
| 1257501868 | 2009-11-06 00:04:28 | 106 117 124 139 144 155 164 176 |
| 1257501929 | 2009-11-06 00:05:29 | 103 118 129 133 146 157 169 173 |
| 1257501989 | 2009-11-06 00:06:29 | 100 119 128 131 142 151 169 173 |
| 1257502049 | 2009-11-06 00:07:29 | 106 111 127 139 141 152 169 173 |
| 1257502109 | 2009-11-06 00:08:29 | 101 112 123 135 143 154 164 178 |
| 1257502170 | 2009-11-06 00:09:30 | 108 112 128 139 145 156 169 176 |
| 1257502230 | 2009-11-06 00:10:30 | 104 115 127 137 141 159 169 176 |
| 1257502290 | 2009-11-06 00:11:30 | 101 117 128 134 148 151 169 175 |
| 1257502350 | 2009-11-06 00:12:30 | 107 117 127 130 146 154 169 175 |
| 1257502410 | 2009-11-06 00:13:30 | 104 110 126 138 143 156 169 175 |
| 1257502471 | 2009-11-06 00:14:31 | 101 110 123 134 145 158 164 170 |
| 1257502531 | 2009-11-06 00:15:31 | 107 113 122 132 141 159 164 170 |
| 1257502591 | 2009-11-06 00:16:31 | 104 113 121 137 140 153 164 170 |
| 1257502651 | 2009-11-06 00:17:31 | 100 115 121 135 146 154 164 170 |
| 1257502712 | 2009-11-06 00:18:32 | 107 116 126 131 148 156 161 175 |
| 1257502772 | 2009-11-06 00:19:32 | 103 118 125 139 145 159 161 175 |
| 1257502832 | 2009-11-06 00:20:32 | 100 118 124 135 141 151 161 175 |
| 1257502892 | 2009-11-06 00:21:32 | 106 111 125 133 140 154 161 174 |
| 1257502952 | 2009-11-06 00:22:32 | 103 113 124 130 147 156 161 174 |
| 1257503013 | 2009-11-06 00:23:33 | 100 114 129 134 148 158 166 172 |
| 1257503073 | 2009-11-06 00:24:33 | 106 116 120 132 145 159 166 171 |
| 1257503133 | 2009-11-06 00:25:33 | 103 116 129 130 144 153 166 179 |
| 1257503193 | 2009-11-06 00:26:33 | 109 119 128 138 140 154 166 179 |
| 1257503253 | 2009-11-06 00:27:33 | 108 111 129 135 147 158 166 179 |
| 1257503314 | 2009-11-06 00:28:34 | 103 112 123 139 149 150 161 176 |
| 1257503374 | 2009-11-06 00:29:34 | 109 112 122 137 147 151 161 176 |
| 1257503434 | 2009-11-06 00:30:34 | 106 114 123 135 144 155 161 176 |
| 1257503494 | 2009-11-06 00:31:34 | 102 116 122 131 140 156 161 175 |
| 1257503555 | 2009-11-06 00:32:35 | 109 117 127 137 142 158 167 171 |
| 1257503615 | 2009-11-06 00:33:35 | 105 118 126 135 149 159 167 171 |
| 1257503675 | 2009-11-06 00:34:35 | 102 110 127 132 147 153 166 170 |
| 1257503735 | 2009-11-06 00:35:35 | 108 112 126 138 144 154 166 170 |
| 1257503795 | 2009-11-06 00:36:35 | 105 113 121 134 146 156 164 176 |
| 1257503856 | 2009-11-06 00:37:36 | 101 113 129 135 148 159 160 177 |
| 1257503916 | 2009-11-06 00:38:36 | 107 115 128 133 145 150 160 177 |
| 1257503976 | 2009-11-06 00:39:36 | 102 116 122 139 147 152 165 174 |
| 1257504036 | 2009-11-06 00:40:36 | 101 118 123 137 145 156 165 174 |
| 1257504097 | 2009-11-06 00:41:37 | 105 119 128 131 147 157 162 170 |
| 1257504157 | 2009-11-06 00:42:37 | 102 119 127 139 144 159 162 170 |
| 1257504217 | 2009-11-06 00:43:37 | 108 112 128 137 140 152 162 179 |
| 1257504277 | 2009-11-06 00:44:37 | 105 114 127 132 147 154 162 179 |
| 1257504337 | 2009-11-06 00:45:37 | 103 114 126 130 145 155 162 179 |
| 1257504398 | 2009-11-06 00:46:38 | 108 115 121 136 147 157 167 174 |
| 1257504458 | 2009-11-06 00:47:38 | 105 117 122 134 144 151 167 174 |
| 1257504518 | 2009-11-06 00:48:38 | 101 110 121 130 140 152 167 174 |
| 1257504578 | 2009-11-06 00:49:38 | 100 110 120 137 149 156 167 173 |
| 1257504638 | 2009-11-06 00:50:38 | 106 112 121 135 146 157 167 173 |
| 1257504699 | 2009-11-06 00:51:39 | 101 113 125 131 147 159 162 171 |
| 1257504759 | 2009-11-06 00:52:39 | 108 115 124 137 144 152 162 179 |
| 1257504819 | 2009-11-06 00:53:39 | 104 117 125 135 143 154 162 178 |
| 1257504879 | 2009-11-06 00:54:39 | 101 118 120 131 144 156 167 176 |
| 1257504940 | 2009-11-06 00:55:40 | 108 119 125 135 146 158 165 171 |
| 1257505000 | 2009-11-06 00:56:40 | 104 111 126 133 143 151 164 171 |
| 1257505060 | 2009-11-06 00:57:40 | 101 112 125 130 149 153 164 171 |
| 1257505120 | 2009-11-06 00:58:40 | 107 114 124 138 148 154 164 171 |
| 1257505180 | 2009-11-06 00:59:40 | 104 114 123 134 145 158 164 170 |
+------------+---------------------+---------------------------------+
60 rows in set (1.09 sec)
mysql> exit