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? Link to comment https://forums.phpfreaks.com/topic/278430-create-mysql-database-using-mysql-command/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.