insert into table(col1,co2)...col1是常量,col2是子查询出来的值
来源:互联网 发布:淘宝不能卖pos 编辑:程序博客网 时间:2024/04/30 04:58
insert into t_busi_main_presend(id,clientid)select '111',t.id from t_sys_client t where t.code='古风尚';
注意,当insert的值有子查询出来的,values关键字就不要了。
其中id是常量,client是子查询出来的。写这种sql,可以先把下面select出来的值执行一遍,看值是否正确。
- insert into table(col1,co2)...col1是常量,col2是子查询出来的值
- row_number() over(partition by col1 order by col2)的用法
- Row_number () over (partition by col1 order by col2)的用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)/ ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)
- 用NPOI操作EXCEL关于HSSFClientAnchor(dx1,dy1,dx2,dy2,col1,row1,col2,row2)的参数
- oracle中row_number() OVER (PARTITION BY COL1 ORDER BY COL2)
- row_number() OVER (PARTITION BY COL1 ORDER BY COL2)
- row_number() OVER (PARTITION BY COL1 ORDER BY COL2)
- row_number()over(partition by col1 order by col2)
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- row_number() OVER (PARTITION BY COL1 ORDER BY COL2)
- sum(col1) over(partition by col2 order by col3 )
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- ROWNUMBER() OVER( PARTITION BY COL1 ORDER BY COL2)用法
- c++/c语言绘制杨辉三角形
- 黑马程序员_java初步
- Ubuntu配置网络文件共享服务器NFS
- 2011.11.11找工作小结
- Ajax常见问题解决方案
- insert into table(col1,co2)...col1是常量,col2是子查询出来的值
- u-boot分析(二) u-boot的编译及配置 mkconfig
- 对vc中radio单选按钮进行初始化!...
- 不只是FileNet Link的简单使用
- list
- 动态生成表格
- 首个文章
- mount命令+nfs挂载失败原因
- TQ2440 查询法实现按键LED的功能