向mysql插表失败qt5_QT创建QMYSQL数据库表格失败，求解

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

#include

#include

int main(int argc, char *argv[])

{

QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL"); //添加数据库驱动

db.setHostName("localhost");

db.setDatabaseName("test");

db.setPort(3306);

db.setUserName("name");

db.setPassword("654321");

bool ret=db.open();

if(ret)

qDebug()<

QSqlQuery query(db); //以下执行相关SQL语句

query.exec("create table student (name varchar(8),id int primary key)"); //新建student表，id设置为主键，还有一个name项

query.exec("insert into student values('xiaogang',4)");

query.exec("insert into student values('xiaoming',5)");

query.exec("insert into student values('xiaohong',6)"); //向表中插入3条记录

query.exec("select name, id from student where id >= 5"); //查找表中id >=2 的记录的id项和name项的值

while(query.next()) //query.next()指向查找到的第一条记录，然后每次后移一条记录

{

int ele0 = query.value(1).toInt(); //query.value(0)是id的值，将其转换为int型

QString ele1 =query.value(0).toString();

qDebug() << ele0 <

}

/*qDebug() << "Available drivers:";

QStringList drivers = QSqlDatabase::drivers();

foreach(QString driver, drivers)

qDebug() << "\t" << driver;

return a.exec();*/

return a.exec();

}