title: How to clear a SQL Table when Database has a point in its name (bash script)?
body: <p><em>The script is in <code>/etc/cron.daily</code>.</em></p>
  
  <hr>
  
  <p>When I had <code>database name = baseName</code> and the <code>table = tableName</code>, the below script to empty the table worked well :  </p>
  
  <pre><code>#!/bin/bash
  
  mysql -u root --password=PASSWD -e "DELETE FROM baseName.tableName"
  </code></pre>
  
  <hr>
  
  <p>But I needed to rename the database in <code>baseName.fr.value</code> so I basically modified my script to </p>
  
  <pre><code>#!/bin/bash
  
  mysql -u root --password=PASSWD -e "DELETE FROM baseName.fr.value.tableName"
  </code></pre>
  
  <p>But I got an <code>You have an error in your SQL syntax, check the manual...</code></p>
  
  <hr>
  
  <p>So what's the correct syntax when there's a <code>.</code> in the database name ? </p>