jackhard Posted May 27, 2013 Share Posted May 27, 2013 I am having a problem when trying to create a database using mysql command. The code i am using is; 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();}When i try to run this code i always get an error saying that i have an error in mysql syntax near "fancydb"...but when I put the name in the command like: "CREATE DATABASE facnydb;" it works. Can anyone explain to me why is the error only happening when i try and use parameters? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.