[Gllug] Bash: Escaping a *

[Dean Wilson]

Darren Beale wrote:
> ---8<---
> SQL="
> USE $database;
> CREATE TABLE $foo LIKE $bar;
> INSERT INTO $foo SELECT * FROM $bar WHERE $predicate;
> "
> 
> echo $SQL | /usr/local/mysql/bin/mysql -N
> --->8---
> How do I stop the * being expanded?

Try echo "$SQL" instead.

HTH
  Dean
-- 
Dean Wilson               http://www.unixdaemon.net
Profanity is the one language all programmers understand
--- Anon
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug