|
本帖最后由 study_wen 于 2013-9-22 20:39 编辑
QString str,str1;
int birdge;
QSqlQuery query,query1;
str = "select *from table2 where birdget = 2";
query.exec(str);
birdge = query.value(0).toint;
query.exec("select mac from table1");
while(query.next())
{
QString value = query.value(0).toString();
str1.sprintf("insert into table2 values(%d,'%s')",birdge++,value.toAscill().data());
query1.exec(str1);
}
你试试
或者上述str = "select *from table2 where birdget = 1";
然后 str1.sprintf("insert into table2 values(%d,'%s')",++birdge,value.toAscill().data()); |
|