mysql - 在 bash 中从 mysql 读取多行时出错

Question

查看 Internet 上在 bash 中从 mysql db 读取多行的方法，我正在执行以下操作:

i=0
while read relation_id
do
  echo "Record $(( i++ )) $relation_id"
done < <(mysql -u$db_user -p$db_password -h$db_host -D$db_name -se "SELECT id where connection_id=$id")

但不幸的是我收到以下错误:

temp.sh: line 11: syntax error near unexpected token `<'
temp.sh: line 11: `done < <(mysql -u$db_user -p$db_password -h$db_host -D$db_name -se "SELECT id where connection_id=$id")'

请帮助我知道我做错了什么。

Answer 1

去掉空格done <<(mysql这里应该是<<不是<