title: Create mysql database using mysql command
body: <p>I am having a problem when trying to create a database using mysql command. The code i am using is;</p>
  
  <pre><code>using (MySqlConnection con = connect_db())
  {
      con.Open();
  
      MySqlCommand cmd = new MySqlCommand("CREATE DATABASE @name;", con);
  
      cmd.Parameters.AddWithValue("@name", "fancydb");
  
      try
      {
          cmd.ExecuteNonQuery();
      }
      catch (Exception exc)
      {                   
          return;
      }
      cmd.Dispose();
      con.Close();
      con.Dispose();
  }
  </code></pre>
  
  <p>When I try to run this code I always get an error saying that I have an </p>
  
  <blockquote>
    <p>error in mysql syntax near "fancydb"</p>
  </blockquote>
  
  <p>but when I put the name in the command like: <code>"CREATE DATABASE facnydb;"</code> it works. Can anyone explain to me why is the error only happening when I try and use parameters?</p>