Writing to variable from MySQL databases in bash script

Question

I have a problem with writing in the variable from table in MySQL database.

DB="--user=$OSD_USERNAME \
    --password=$OSD_PASSWORD \ 
    --database=$OSD_DB -N";
mysql --user="$user" \
      --password="$password" \
      --database="$database" \
      --execute="DROP DATABASE $user; CREATE DATABASE $database;"

id_customer = $(echo "SELECT id FROM customers WHERE customers.customer='John'"| mysql $DB)

My problem is that id_customer is still empty. When I connect to mysql databases and put there this:

SELECT id FROM customers WHERE customers.customer='John'

then it give me table like this

+----+
| id |
+----+
|  1 | 
+----+

It won't put on formatting if you call it with a piped in script. Try it out. — tadman
– tadman, Commented May 21, 2014 at 23:44

Eugeniy · Accepted Answer · 2014-05-21 23:56:26Z

2

Only empty, no errors? Try remove spaces between variable name and $

answered May 21, 2014 at 23:56

Eugeniy

365 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Writing to variable from MySQL databases in bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related