MariaDB テキストに記述されたクエリを実行する

source ファイル名

USE foo;
SELECT * FROM tbl1;

> source /hoge.txt

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
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | itiro  |   10 |
|  2 | jiro   |   20 |
|  3 | saburo |   30 |
|  4 | siro   |   40 |
|  5 | goro   |   50 |
+----+--------+------+
5 rows in set (0.000 sec)

> \. /hoge.txt

Database changed
+----+--------+------+
| id | name   | age  |
+----+--------+------+
|  1 | itiro  |   10 |
|  2 | jiro   |   20 |
|  3 | saburo |   30 |
|  4 | siro   |   40 |
|  5 | goro   |   50 |
+----+--------+------+
5 rows in set (0.000 sec)