TIL: How to pass MySQL queries as variables in Bash
Note: I also learned how to handle query blocks with Bash here documents. Most of what I’ve done in the past with MySQL and Bash has been limited to single-line selects, so Yay!, learning.
#!/bin/bash db_server=servername.local db_user=millhouse db_pass=derpderpderp user_id=$(mysql -u$db_user -p$db_pass $db_server GET_USER_ID USE main; SELECT user_id FROM users WHERE username="dave"; GET_USER_ID ) echo "Dave's User ID is $user_id"
It’s the small things in life…
Read other posts