qtcreator qsqlquery prepare总是提示mysql的语法错误,请大神解答为什么?
void func(QString tabname,QString column1,QString column2)
{
QString sql = "CREATE TABLE IF NOT EXISTS :tabname (:column1 varchar(20)) NOT NULL, :column2 varchar(20) PRIMARY KEY)";
QSqlquery query;
query.prepare(sql);
qDebug() << query.lasterror();
query.bindvalue(":tabname",tabname);
query.bindvalue(":column1",column1);
query.bindvalue(":column2",column2);
query.exec();
}
_______________________
error: qsqlerror(1064,qmysql3:unable to prepare a statement, you have a error in your sql syntax)