MySql and Parameters...

[Diego Guidi]

This code in my program:

string commandString = "CREATE TABLE ?pTable (ID BIGINT(20) AUTO_INCREMENT NOT NULL, SHAPE POINT NOT NULL," +
" PRIMARY KEY(ID), SPATIAL KEY (SHAPE)) ENGINE=MyISAM AUTO_INCREMENT=1";
MySqlCommand command = new MySqlCommand(commandString, conn);
command.Parameters.Add("pTable", "Table1");
command.ExecuteNonQuery();

Launch this exception:
#42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
syntax to use near ''FeatureClass1' (ID BIGINT(20) AUTO_INCREMENT NOT NULL, SHAPE POINT NOT NULL, PR' at line 1
Please note '' in near ''FeatureClass1' ...

But if from query builder i use:

CREATE TABLE Table1 (ID BIGINT(20) AUTO_INCREMENT NOT NULL, SHAPE POINT NOT NULL, PRIMARY KEY(ID), SPATIAL KEY (SHAPE)) ENGINE=MyISAM AUTO_INCREMENT=1

all works correctly; but:

CREATE TABLE 'Table1' (ID BIGINT(20) AUTO_INCREMENT NOT NULL, SHAPE POINT NOT NULL, PRIMARY KEY(ID), SPATIAL KEY (SHAPE)) ENGINE=MyISAM AUTO_INCREMENT=1

launch the same exception of my code.

Any suggestions?