mysql - bash中取mysql数据，函数read读取每一句作为变量

Question

我试图从我的数据库中获取变量，我在数据库中有一个值我有 2 个单词，但下面的命令将其视为 2 个变量。

是否有任何更改以我的方式获取它？

   mysql -uroot -proot --database=symfony -se "SELECT cameras.source, cameras.name, investments.name, users.username FROM cameras JOIN investments ON investments.id = cameras.investment_id JOIN users ON users.id = investments.user_id;" | while read source camera investment username; do

mysql 结果:

| source                                                                 | name         | name       | username |
+------------------------------------------------------------------------+--------------+------------+----------+
| rtsp://vlc:vlc@test/cam/realmonitor?channel=1&subtype=0   | camera 1     | investment |  user    |
+------------------------------------------------------------------------+--------------+------------+----------+

狂欢:

echo "source :"$source
echo "camera :" :$camera
echo "investments: " $investments
echo "username: " $username

结果:

source :rtsp://vlc:vlc@test/cam/realmonitor?channel=1&subtype=0channel=1&subtype=0
camera : investment
investments: 1
username:  investment username

Answer 1

为避免 camera.name 中的空格被混淆为分隔符，您可以将空格替换为另一个字符，例如 _

 SELECT cameras.source
      , replace(cameras.name, ' ', '_')
      , investments.name, users.username 
  FROM cameras 
  JOIN investments ON investments.id = cameras.investment_id 
  JOIN users ON users.id = investments.user_id;