質問編集履歴
2
exit 0の削除
test
CHANGED
File without changes
|
test
CHANGED
@@ -31,7 +31,6 @@
|
|
31
31
|
echo "db error."
|
32
32
|
exit 1
|
33
33
|
fi
|
34
|
-
exit 0
|
35
34
|
|
36
35
|
# ②①の配列の値のidにカラム名mail_idが部分一致する行をSELECTで抽出
|
37
36
|
|
1
変数名の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -34,9 +34,8 @@
|
|
34
34
|
exit 0
|
35
35
|
|
36
36
|
# ②①の配列の値のidにカラム名mail_idが部分一致する行をSELECTで抽出
|
37
|
-
# 配列名は仮に「ID_ARR」とする
|
38
37
|
|
39
|
-
select_sql="select * from dev_table where mail_id like "%${
|
38
|
+
select_sql="select * from dev_table where mail_id like "%${column}%""
|
40
39
|
result=$(mysql -u${USER2} -p${PASS2} -D${DB2} -h ${HOST2} -e "${select_sql}")
|
41
40
|
|
42
41
|
```
|
@@ -44,7 +43,7 @@
|
|
44
43
|
|
45
44
|
|
46
45
|
|
47
|
-
↓
|
46
|
+
↓columnの中身(この結果を配列にしたい)
|
48
47
|
```
|
49
48
|
host@./mysql.sh
|
50
49
|
id
|