String expansion in bash with embedded quotes String expansion in bash with embedded quotes shell shell

String expansion in bash with embedded quotes


bash shell expansion subshell

Because $TARG_DB is within single quotes within the subshell, it's taken literally. Use double quotes there, they won't mess up the subshell. e.g.

$ tmp="a b c"$ echo $tmpa b c$ echo $(echo $tmp)a b c$ echo $(echo "$tmp")a b c$ echo $(echo '$tmp')$tmp$ echo "$(echo '$tmp')"$tmp$ echo "$(echo "$tmp")"a b c

bash shell expansion subshell

Don't wrap it in single-quotes.

There is no need to quote the command substitution $() so you can remove those and use double-quotes inside it.

DB_CREATE=$($MYSQL -u $MyUSER -h $MyHOST -p$MyPASS -Bse "create database $TARG_DB");

bash shell expansion subshell 

TARG_DB="zztest";DB_CREATE="$(${MYSQL} -u ${MyUSER} -h ${MyHOST} -p${MyPASS} -Bse \"create database ${TARG_DB}\")";

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last