回答編集履歴
1
コメントを受けての追記
answer
CHANGED
|
@@ -12,4 +12,16 @@
|
|
|
12
12
|
INSERT INTO table1
|
|
13
13
|
SELECT * FROM table2 WHERE date >= '$1' AND date <= '$2';
|
|
14
14
|
EOF
|
|
15
|
+
```
|
|
16
|
+
#追記：別ファイルにSQLを置く場合
|
|
17
|
+
```sh
|
|
18
|
+
#!/bin/bash
|
|
19
|
+
mysql -uuser -ppwd -D dbname --skip-column-names <<EOF
|
|
20
|
+
set @start_date = '$1', @end_date = '$2';
|
|
21
|
+
source sample.sql;
|
|
22
|
+
EOF
|
|
23
|
+
```
|
|
24
|
+
```sh
|
|
25
|
+
#!/bin/bash
|
|
26
|
+
mysql -uuser -ppwd -D dbname --skip-column-names -e "set @start_date = '$1', @end_date = '$2';source sample.sql;"
|
|
15
27
|
```
|