sql 语句插入结果为select和值混合示例

程序员文章站 2023-10-20 11:22:37

复制代码代码如下: string slctpsql="select id ,"+uid+","+ddd+","+score+",'"+mark+"' ,"+markid+...

 
string slctpsql="select id ,"+uid+","+ddd+","+score+",'"+mark+"' ,"+markid+" ,"+exam.getid()+" from test_paper where testbaseid=(select id from test_base where basetestid="+judgemap.get(i).getid()+" and basetesttype=1) and paperid="+paperbaseinfo.getid(); 

string insertsql="insert into test_paper_record (t_pid,userid,answer,score,mark,markerid,examid )"+slctpsql;

上一篇：黑田孝高：日本战国时期第一军师

下一篇：网站活跃用户与流失用户分析