How to create mysql database table in Qt?

[vivek31]

mydb = QSqlDatabase::addDatabase("QMYSQL");
mydb.setDatabaseName("mylogin");

mydb.setUserName("root");
mydb.setPort(3306);
mydb.setHostName("localhost");
mydb.setPassword("");

if(!mydb.open())
{
qDebug() << "failed" ;
qDebug() << mydb.lastError().text();
}
QSqlQuery qry;
qry.prepare("CREATE TABLE RSA(name varchar(20);");
if(qry.exec())
{
QMessageBox msg;
msg.setText("Data saved");
msg.exec();
mydb.close();
mydb.removeDatabase(QSqlDatabase::defaultConnectio n);
}
else
{
QMessageBox msg2;
msg2.setText("Failed to save data");
msg2.exec();
qDebug() << mydb.lastError().text();
}
}

[neuronet]

What do you want to happen, and what has happened?

[jefftee]

You are missing a right parenthesis on your create statement. Should be the following:



qry.prepare("CREATE TABLE RSA(name varchar(20));");


Edit: I should add that for a DDL statement like this, you could just execute the query directly. The prepare should be used whenever you have parameter substitution needs or will be executing the same query multiple times, etc.