mysql -h irtfweb -u spex -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3866
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 |
+----------------+
| tc208 |
| tc208_sim |
| tc330a |
| tc330a_sim |
| tc330b |
| tc330b_sim |
+----------------+
6 rows in set (0.00 sec)
mysql> SELECT tv_sec, FROM_UNIXTIME(tv_sec) AS date, ch1, ch2, ch3, ch4, ch5, ch6, ch7, ch8
-> FROM tc208_sim
-> WHERE (tv_sec > UNIX_TIMESTAMP('2009-05-06 00:00:00')) AND (tv_sec < UNIX_TIMESTAMP('2009-05-06 01:00:00'))
-> ORDER BY tv_sec DESC;
+------------+---------------------+------+------+------+------+------+------+------+------+
| tv_sec | date | ch1 | ch2 | ch3 | ch4 | ch5 | ch6 | ch7 | ch8 |
+------------+---------------------+------+------+------+------+------+------+------+------+
| 1241607587 | 2009-05-06 00:59:47 | 51 | 52 | 63 | 61 | 65 | 62 | 66 | 64 |
| 1241607464 | 2009-05-06 00:57:44 | 53 | 59 | 60 | 60 | 64 | 66 | 69 | 65 |
| 1241607341 | 2009-05-06 00:55:41 | 57 | 56 | 58 | 60 | 66 | 62 | 65 | 64 |
| 1241607218 | 2009-05-06 00:53:38 | 51 | 53 | 56 | 64 | 66 | 68 | 71 | 70 |
| 1241607095 | 2009-05-06 00:51:35 | 55 | 56 | 55 | 61 | 60 | 66 | 65 | 73 |
| 1241606972 | 2009-05-06 00:49:32 | 52 | 52 | 55 | 60 | 67 | 67 | 62 | 67 |
| 1241606849 | 2009-05-06 00:47:29 | 56 | 59 | 58 | 62 | 65 | 62 | 68 | 73 |
| 1241606726 | 2009-05-06 00:45:26 | 55 | 56 | 62 | 59 | 63 | 65 | 68 | 65 |
| 1241606603 | 2009-05-06 00:43:23 | 53 | 57 | 58 | 62 | 58 | 67 | 65 | 70 |
| 1241606480 | 2009-05-06 00:41:20 | 52 | 60 | 58 | 58 | 60 | 67 | 66 | 68 |
| 1241606357 | 2009-05-06 00:39:17 | 54 | 61 | 63 | 57 | 58 | 68 | 69 | 72 |
| 1241606234 | 2009-05-06 00:37:14 | 55 | 59 | 55 | 56 | 64 | 60 | 69 | 66 |
| 1241606111 | 2009-05-06 00:35:11 | 52 | 58 | 55 | 63 | 60 | 63 | 63 | 69 |
| 1241605988 | 2009-05-06 00:33:08 | 58 | 54 | 54 | 60 | 58 | 62 | 64 | 73 |
| 1241605865 | 2009-05-06 00:31:05 | 54 | 56 | 56 | 62 | 64 | 69 | 69 | 68 |
| 1241605742 | 2009-05-06 00:29:02 | 51 | 52 | 58 | 61 | 62 | 69 | 69 | 69 |
| 1241605619 | 2009-05-06 00:26:59 | 59 | 60 | 56 | 56 | 63 | 66 | 63 | 68 |
| 1241605496 | 2009-05-06 00:24:56 | 58 | 61 | 57 | 60 | 62 | 66 | 63 | 72 |
| 1241605373 | 2009-05-06 00:22:53 | 50 | 57 | 58 | 61 | 58 | 62 | 69 | 64 |
| 1241605250 | 2009-05-06 00:20:50 | 57 | 57 | 63 | 56 | 60 | 62 | 65 | 66 |
| 1241605127 | 2009-05-06 00:18:47 | 51 | 54 | 59 | 60 | 67 | 66 | 64 | 73 |
| 1241605004 | 2009-05-06 00:16:44 | 58 | 55 | 56 | 58 | 64 | 63 | 63 | 71 |
| 1241604881 | 2009-05-06 00:14:41 | 59 | 58 | 56 | 56 | 60 | 63 | 70 | 64 |
| 1241604758 | 2009-05-06 00:12:38 | 50 | 52 | 55 | 63 | 59 | 65 | 65 | 67 |
| 1241604635 | 2009-05-06 00:10:35 | 59 | 60 | 63 | 63 | 58 | 66 | 71 | 72 |
| 1241604512 | 2009-05-06 00:08:32 | 55 | 56 | 59 | 56 | 60 | 60 | 63 | 73 |
| 1241604388 | 2009-05-06 00:06:28 | 50 | 54 | 57 | 65 | 67 | 66 | 63 | 69 |
| 1241604265 | 2009-05-06 00:04:25 | 57 | 54 | 55 | 57 | 65 | 60 | 66 | 67 |
| 1241604142 | 2009-05-06 00:02:22 | 56 | 61 | 58 | 64 | 66 | 62 | 67 | 64 |
| 1241604019 | 2009-05-06 00:00:19 | 54 | 61 | 55 | 64 | 60 | 68 | 67 | 73 |
+------------+---------------------+------+------+------+------+------+------+------+------+
30 rows in set (0.07 sec)
mysql> exit