
ファイル 編集 ウィンドウ ヘルプ
Checking our log DB
$ mysql -u vsearch -p vsearchlogDB
Enter password:
Welcome to MySQL monitor...
mysql> select * from log;
+----+---------------------+--------------------------+---------+-----------+----------------+----------------------+
| id | ts | phrase | letters | ip | browser_string | results |
+----+---------------------+
--------------------------+---------+-----------+----------------+----------------------+
| 1 | 2016-03-09 13:40:46 | life, the uni ... ything | aeiou | 127.0.0.1 | firefox | {'u', 'e', 'i', 'a'} |
| 2 | 2016-03-09 13:42:07 | hitch-hiker | aeiou | 127.0.0.1 | safari | {'i', 'e'} |
| 3 | 2016-03-09 13:42:15 ...