FUDforum: PHP discussions » Create mysql database using mysql command

Home » General » PHP discussions » Create mysql database using mysql command

Show: Today's Messages :: Polls :: Message Navigator

Create mysql database using mysql command [message #168578]

Mon, 27 May 2013 10:54

Jack Hard
Messages: 7
Registered: December 2012

Karma:

Junior Member

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?

Report message to a moderator

[Message index]

		Create mysql database using mysql command By: Jack Hard on Mon, 27 May 2013 10:54
		Re: Create mysql database using mysql command By: ash on Fri, 03 October 2014 17:27
		Re: Create mysql database using mysql command By: ash on Fri, 03 October 2014 17:31
		Re: Create mysql database using mysql command By: motorinsurance16 on Tue, 04 August 2015 15:07

Previous Topic:	Debugging an embedded device using TCF
Next Topic:	Using PHP to send mail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 22:48:41 GMT 2024

Total time taken to generate the page: 0.04313 seconds