escaping hyphens with the mysql commandline tool

Question

Is there a way to escape a hyphen with the mysql commandline tool?

I basically need to do this:

$ mysql -hlocalhost -uuser -puser information_schema -e "CREATE DATABASE foo-bar"

Using mysqladmin is not an option due to the framework I'm within.

Answer 1

"CREATE DATABASE \`foo-bar\`"

Answer 2

Hi!

Using backticks and using this way of piping the statement to mysql works:

echo 'create database `foo-bar2`' | mysql -uuser -ppassword

// John