Bash loop not adding to array

Question

I am trying to add elements to an array in bash. I am querying and looping over the query.

delete_arr=()
delete_arr+=("test")
mysql -e "$sql_statement" | while read directory_name; do 
if [ $counter -gt 0 ]
   then
     delete_arr+=($directory_name)
fi
let counter=counter+1
done

 for i in "${delete_arr[*]}"; do echo "$i"; done

The only output I am getting is test. I should be getting a lot more data. The query works and the data gets added to the array in the loop however when I jump out of the loop the array only contains test.I am doing nothing to reset the array.

See also [BashFAQ/024](http://mywiki.wooledge.org/BashFAQ/024) — Benjamin W., Mar 04 '20 at 16:29

score 1 · Accepted Answer · answered Mar 04 '20 at 15:44

1

In the pipe, you are implicitly creating a new subshell with its own namespace. Try avoiding the pipe:

delete_arr=()
delete_arr+=("test")
while read directory_name
do 
    if [ "$counter" -gt 0 ]
    then
        delete_arr+=("$directory_name")
    fi
    counter=$((counter+1))
done < <(mysql -e "$sql_statement")

for i in "${delete_arr[@]}"; do echo "$i"; done

answered Mar 04 '20 at 15:44

Poshi

5,332
3
15
32

I tried that but I am getting an error `done < <(mysql -e "$sql_statement")` – newdeveloper Mar 04 '20 at 15:59
Which error are you getting? – Poshi Mar 04 '20 at 16:34
That is the error. `line 103: `done < <(mysql -e "$sql_statement")'` – newdeveloper Mar 04 '20 at 17:20
`syntax error near unexpected token `<' done < <(mysql -e "$sql")'` Is the full error – newdeveloper Mar 04 '20 at 17:36
fixed. I had `#!/bin/sh` but i needed `#!/bin/bash` – newdeveloper Mar 04 '20 at 18:04

Bash loop not adding to array

1 Answers1