Question

asp.net 使用 Mysql数据库的MySqlParameter错误？？

代码如下：
string table = ConfigurationManager.AppSettings["table"].ToString();
string SqlSelect = "SELECT * FROM ?table where INBOXID=(select min(INBOXID) from ?table2)";
MySqlParameter[] mysqlpar ={ new MySqlParameter("?table", table), new MySqlParameter("?table2",table) };

错误：
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''t_inbox001' where INBOXID=(select min(INBOXID) from 't_inbox001')' at line 1

Answer 1

看看是不是关键字冲突，把 ?table 的table 换别的名称