title: SOLVE mysql linux bash with coloumn name have "-" & query mysql from file
body: <p>i have problem with query mysql on linux bash, my query have 2 coloumn with "-" :</p>
  
  <pre><code>mysql -u root -pPass mydb -e "select `work-time` from work where `work-time`&gt; '2013-0-3-07 00:00:00'";
  </code></pre>
  
  <p>but the result :</p>
  
  <pre><code>bash: work-time: command not found
  </code></pre>
  
  <p>i know the problem this quote "`" but how solve this ?</p>
  
  <p><strong>I UPDATE MY QUERY</strong></p>
  
  <p><strong>SOLVE query on line</strong> : </p>
  
  <pre><code>mysql -u root -pPass mydb -e "select \`work-time\` from work where \`work-time\`&gt; '2013-0-3-07 00:00:00'"
  </code></pre>
  
  <p><strong>Other Question</strong></p>
  
  <p>If i save my query on file, and query like this </p>
  
  <pre><code> mysql -u root -pPass mydb &lt; query.sql
  </code></pre>
  
  <p>got error :</p>
  
  <pre><code>ERROR at line 1: Unknown command '\`'.
  </code></pre>
  
  <p><strong>SOLVE query from file with standard query</strong></p>
  
  <pre><code>select `work-time` from work where `work-time`&gt; '2013-0-3-07 00:00:00'
  </code></pre>
  
  <p>save query to file eg. query.sql, and query like this :</p>
  
  <pre><code>mysql -u root -pPass mydb &lt; query.sql
  </code></pre>