MySQL コマンドの履歴と結果をファイルに記述する

tee ファイル名

mysql> tee result.txt

mysql> select * from tbl1;
ERROR 1046 (3D000): No database selected

mysql> use foo;
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> select * from tbl1;
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | taro   |   10 |
|  2 | jiro   |   20 |
|  3 | saburo |   50 |
|  4 | jiro   |   20 |
|  5 | taro   |   50 |
+----+--------+------+
5 rows in set (0.00 sec)

mysql> system cat result.txt

mysql> select * from tbl1;
ERROR 1046 (3D000): No database selected

mysql> use foo;
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> select * from tbl1;
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | taro   |   10 |
|  2 | jiro   |   20 |
|  3 | saburo |   50 |
|  4 | jiro   |   20 |
|  5 | taro   |   50 |
+----+--------+------+
5 rows in set (0.00 sec)

mysql> notee