sql 语句插入结果为select和值混合示例
时间:2024-01-29 09:12:42
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;
标签:sql语句,插入结果,select
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
SQL Server技巧之快速得到表的记录总数
2011-01-04 14:36:00
![](https://img.aspxhome.com/file/UploadPic/20111/20111420216938s.jpg)
Python实现的序列化和反序列化二叉树算法示例
2021-06-11 07:14:23
将python文件打包成EXE应用程序的方法
2022-07-09 16:01:12
![](https://img.aspxhome.com/file/2023/5/123685_0s.jpg)
Vue2.0系列之过滤器的使用
2024-04-10 10:32:24
![](https://img.aspxhome.com/file/2023/9/139769_0s.png)
Go语言中嵌入C语言的方法
2024-04-25 15:05:50
Python OpenCV高斯金字塔与拉普拉斯金字塔的实现
2021-09-02 12:31:06
![](https://img.aspxhome.com/file/2023/9/125039_0s.jpg)
python操作小程序云数据库实现简单的增删改查功能
2024-01-20 08:53:46
![](https://img.aspxhome.com/file/2023/8/97628_0s.jpg)
SQLSERVER2008中CTE的Split与CLR的性能比较
2024-01-28 06:56:04
![](https://img.aspxhome.com/file/2023/4/110954_0s.png)
Python OpenCV学习之图像形态学
2022-01-16 21:48:29
![](https://img.aspxhome.com/file/2023/6/93746_0s.jpg)
Python机器学习应用之朴素贝叶斯篇
2024-01-02 23:11:15
![](https://img.aspxhome.com/file/2023/0/101030_0s.png)
javascript实现简单的可随机变色网页计算器示例
2024-04-16 09:37:07
![](https://img.aspxhome.com/file/2023/1/136581_0s.png)
《色彩解答》系列之三 色彩对比
2008-02-17 14:40:00
![](https://img.aspxhome.com/file/UploadPic/20082/17/2008217144426798s.png)
BigPipe:高性能的"流水线技术"网页
2010-11-02 12:47:00
![](https://img.aspxhome.com/file/UploadPic/201011/2/01-84s.jpg)
教你如何在SQL Server计算机列和平均值
2009-01-20 15:10:00
解析MySQL索引的作用
2024-01-20 09:51:03
![](https://img.aspxhome.com/file/2023/5/82255_0s.png)
PHP入门速成(3)
2023-11-20 18:48:03
已安装tensorflow-gpu,但keras无法使用GPU加速的解决
2021-08-15 12:17:42
![](https://img.aspxhome.com/file/2023/6/81736_0s.jpg)
Go语言实现一个简单的并发聊天室的项目实战
2024-02-15 03:40:33
详解go语言单链表及其常用方法的实现
2024-02-21 03:13:41
![](https://img.aspxhome.com/file/2023/2/109742_0s.png)
python threading模块操作多线程介绍
2021-03-16 20:02:13