当前位置：首页 > 编程日记 > 正文

[摘]终于找到一个有助理解left/right/full outer join的例子

编程日记 2024-05-28 09:10:00

近日在学习《Understading DB2》的时候找到了一个例子，对于理解 left/right/full 三种 outer join 的大有裨益。

先看样本数据，来自DB2的示例数据库 sample：

db2 => insert into employee values('99999','killkill','N','Huang',null,null,null,'nothing',16,'M',null,null,null,null) ;     
DB20000I  The SQL command completed successfully.db2 => SELECT empno, firstnme, lastname, workdept | db2 => SELECT deptno, deptname from department order by 1;
db2 (cont.) => FROM employee order by 4;          |                                                           |              
EMPNO  FIRSTNME     LASTNAME        WORKDEPT      | DEPTNO DEPTNAME                              
------ ------------ --------------- --------      | ------ ------------------------------------  
000010 CHRISTINE    HAAS            A00           | A00    SPIFFY COMPUTER SERVICE DIV.          
000110 VINCENZO     LUCCHESSI       A00           | B01    PLANNING                              
000120 SEAN         O'CONNELL       A00           | C01    INFORMATION CENTER                    
200010 DIAN         HEMMINGER       A00           | D01    DEVELOPMENT CENTER                    
200120 GREG         ORLANDO         A00           | D11    MANUFACTURING SYSTEMS                 
000020 MICHAEL      THOMPSON        B01           | D21    ADMINISTRATION SYSTEMS                
000030 SALLY        KWAN            C01           | E01    SUPPORT SERVICES                      
000130 DELORES      QUINTANA        C01           | E11    OPERATIONS                            
000140 HEATHER      NICHOLLS        C01           | E21    SOFTWARE SUPPORT                      
200140 KIM          NATZ            C01           | F22    BRANCH OFFICE F2                      
000060 IRVING       STERN           D11           | G22    BRANCH OFFICE G2                      
000150 BRUCE        ADAMSON         D11           | H22    BRANCH OFFICE H2                      
000160 ELIZABETH    PIANKA          D11           | I22    BRANCH OFFICE I2                      
000170 MASATOSHI    YOSHIMURA       D11           | J22    BRANCH OFFICE J2                      
000180 MARILYN      SCOUTTEN        D11           |                                              
000190 JAMES        WALKER          D11           |   14 record(s) selected.                     
000200 DAVID        BROWN           D11           |
000210 WILLIAM      JONES           D11           |
000220 JENNIFER     LUTZ            D11           |
200170 KIYOSHI      YAMAMOTO        D11           |
200220 REBA         JOHN            D11           |
000070 EVA          PULASKI         D21           |
000230 JAMES        JEFFERSON       D21           |
000240 SALVATORE    MARINO          D21           |
000250 DANIEL       SMITH           D21           |
000260 SYBIL        JOHNSON         D21           |
000270 MARIA        PEREZ           D21           |
200240 ROBERT       MONTEVERDE      D21           |
000050 JOHN         GEYER           E01           |
000090 EILEEN       HENDERSON       E11           |
000280 ETHEL        SCHNEIDER       E11           |
000290 JOHN         PARKER          E11           |
000300 PHILIP       SMITH           E11           |
000310 MAUDE        SETRIGHT        E11           |
200280 EILEEN       SCHWARTZ        E11           |
200310 MICHELLE     SPRINGER        E11           |
000100 THEODORE     SPENSER         E21           |
000320 RAMLAL       MEHTA           E21           |
000330 WING         LEE             E21           |
000340 JASON        GOUNOT          E21           |
200330 HELENA       WONG            E21           |
200340 ROY          ALONZO          E21           |
99999  killkill     Huang           -             |

注意，我故意插了一条没有对应部门的测试数据到 employee 表中，现在看看 left/right/full out join 的结果：

LEFT OUT JOIN

db2 => SELECT empno, firstnme, lastname, deptname
db2 (cont.) => FROM employee LEFT OUTER JOIN department
db2 (cont.) => ON workdept = deptno
db2 (cont.) => ;EMPNO  FIRSTNME     LASTNAME        DEPTNAME                            
------ ------------ --------------- ------------------------------------
000010 CHRISTINE    HAAS            SPIFFY COMPUTER SERVICE DIV.        
000020 MICHAEL      THOMPSON        PLANNING                            
000030 SALLY        KWAN            INFORMATION CENTER                  
000050 JOHN         GEYER           SUPPORT SERVICES                    
000060 IRVING       STERN           MANUFACTURING SYSTEMS               
000070 EVA          PULASKI         ADMINISTRATION SYSTEMS              
000090 EILEEN       HENDERSON       OPERATIONS                          
000100 THEODORE     SPENSER         SOFTWARE SUPPORT                    
000110 VINCENZO     LUCCHESSI       SPIFFY COMPUTER SERVICE DIV.        
000120 SEAN         O'CONNELL       SPIFFY COMPUTER SERVICE DIV.        
000130 DELORES      QUINTANA        INFORMATION CENTER                  
000140 HEATHER      NICHOLLS        INFORMATION CENTER                  
000150 BRUCE        ADAMSON         MANUFACTURING SYSTEMS               
000160 ELIZABETH    PIANKA          MANUFACTURING SYSTEMS               
000170 MASATOSHI    YOSHIMURA       MANUFACTURING SYSTEMS               
000180 MARILYN      SCOUTTEN        MANUFACTURING SYSTEMS               
000190 JAMES        WALKER          MANUFACTURING SYSTEMS               
000200 DAVID        BROWN           MANUFACTURING SYSTEMS               
000210 WILLIAM      JONES           MANUFACTURING SYSTEMS               
000220 JENNIFER     LUTZ            MANUFACTURING SYSTEMS               
000230 JAMES        JEFFERSON       ADMINISTRATION SYSTEMS              
000240 SALVATORE    MARINO          ADMINISTRATION SYSTEMS              
000250 DANIEL       SMITH           ADMINISTRATION SYSTEMS              
000260 SYBIL        JOHNSON         ADMINISTRATION SYSTEMS              
000270 MARIA        PEREZ           ADMINISTRATION SYSTEMS              
000280 ETHEL        SCHNEIDER       OPERATIONS                          
000290 JOHN         PARKER          OPERATIONS                          
000300 PHILIP       SMITH           OPERATIONS                          
000310 MAUDE        SETRIGHT        OPERATIONS                          
000320 RAMLAL       MEHTA           SOFTWARE SUPPORT                    
000330 WING         LEE             SOFTWARE SUPPORT                    
000340 JASON        GOUNOT          SOFTWARE SUPPORT                    
200010 DIAN         HEMMINGER       SPIFFY COMPUTER SERVICE DIV.        
200120 GREG         ORLANDO         SPIFFY COMPUTER SERVICE DIV.        
200140 KIM          NATZ            INFORMATION CENTER                  
200170 KIYOSHI      YAMAMOTO        MANUFACTURING SYSTEMS               
200220 REBA         JOHN            MANUFACTURING SYSTEMS               
200240 ROBERT       MONTEVERDE      ADMINISTRATION SYSTEMS              
200280 EILEEN       SCHWARTZ        OPERATIONS                          
200310 MICHELLE     SPRINGER        OPERATIONS                          
200330 HELENA       WONG            SOFTWARE SUPPORT                    
200340 ROY          ALONZO          SOFTWARE SUPPORT                    
99999  killkill     Huang           -

RIGHT OUTER JOIN

db2 => SELECT empno, firstnme, lastname, deptname
db2 (cont.) => FROM employee RIGHT OUTER JOIN department
db2 (cont.) => ON workdept = deptno
db2 (cont.) => ;EMPNO  FIRSTNME     LASTNAME        DEPTNAME                            
------ ------------ --------------- ------------------------------------
000010 CHRISTINE    HAAS            SPIFFY COMPUTER SERVICE DIV.        
000020 MICHAEL      THOMPSON        PLANNING                            
000030 SALLY        KWAN            INFORMATION CENTER                  
000050 JOHN         GEYER           SUPPORT SERVICES                    
000060 IRVING       STERN           MANUFACTURING SYSTEMS               
000070 EVA          PULASKI         ADMINISTRATION SYSTEMS              
000090 EILEEN       HENDERSON       OPERATIONS                          
000100 THEODORE     SPENSER         SOFTWARE SUPPORT                    
000110 VINCENZO     LUCCHESSI       SPIFFY COMPUTER SERVICE DIV.        
000120 SEAN         O'CONNELL       SPIFFY COMPUTER SERVICE DIV.        
000130 DELORES      QUINTANA        INFORMATION CENTER                  
000140 HEATHER      NICHOLLS        INFORMATION CENTER                  
000150 BRUCE        ADAMSON         MANUFACTURING SYSTEMS               
000160 ELIZABETH    PIANKA          MANUFACTURING SYSTEMS               
000170 MASATOSHI    YOSHIMURA       MANUFACTURING SYSTEMS               
000180 MARILYN      SCOUTTEN        MANUFACTURING SYSTEMS               
000190 JAMES        WALKER          MANUFACTURING SYSTEMS               
000200 DAVID        BROWN           MANUFACTURING SYSTEMS               
000210 WILLIAM      JONES           MANUFACTURING SYSTEMS               
000220 JENNIFER     LUTZ            MANUFACTURING SYSTEMS               
000230 JAMES        JEFFERSON       ADMINISTRATION SYSTEMS              
000240 SALVATORE    MARINO          ADMINISTRATION SYSTEMS              
000250 DANIEL       SMITH           ADMINISTRATION SYSTEMS              
000260 SYBIL        JOHNSON         ADMINISTRATION SYSTEMS              
000270 MARIA        PEREZ           ADMINISTRATION SYSTEMS              
000280 ETHEL        SCHNEIDER       OPERATIONS                          
000290 JOHN         PARKER          OPERATIONS                          
000300 PHILIP       SMITH           OPERATIONS                          
000310 MAUDE        SETRIGHT        OPERATIONS                          
000320 RAMLAL       MEHTA           SOFTWARE SUPPORT                    
000330 WING         LEE             SOFTWARE SUPPORT                    
000340 JASON        GOUNOT          SOFTWARE SUPPORT                    
200010 DIAN         HEMMINGER       SPIFFY COMPUTER SERVICE DIV.        
200120 GREG         ORLANDO         SPIFFY COMPUTER SERVICE DIV.        
200140 KIM          NATZ            INFORMATION CENTER                  
200170 KIYOSHI      YAMAMOTO        MANUFACTURING SYSTEMS               
200220 REBA         JOHN            MANUFACTURING SYSTEMS               
200240 ROBERT       MONTEVERDE      ADMINISTRATION SYSTEMS              
200280 EILEEN       SCHWARTZ        OPERATIONS                          
200310 MICHELLE     SPRINGER        OPERATIONS                          
200330 HELENA       WONG            SOFTWARE SUPPORT                    
200340 ROY          ALONZO          SOFTWARE SUPPORT                    
-      -            -               BRANCH OFFICE H2                    
-      -            -               BRANCH OFFICE I2                    
-      -            -               BRANCH OFFICE G2                    
-      -            -               DEVELOPMENT CENTER                  
-      -            -               BRANCH OFFICE F2                    
-      -            -               BRANCH OFFICE J2

FULL OUTER JOIN

db2 => SELECT empno, firstnme, lastname, deptname
db2 (cont.) => FROM employee FULL OUTER JOIN department
db2 (cont.) => ON workdept = deptno
db2 (cont.) => ;EMPNO  FIRSTNME     LASTNAME        DEPTNAME                            
------ ------------ --------------- ------------------------------------
000010 CHRISTINE    HAAS            SPIFFY COMPUTER SERVICE DIV.        
000020 MICHAEL      THOMPSON        PLANNING                            
000030 SALLY        KWAN            INFORMATION CENTER                  
000050 JOHN         GEYER           SUPPORT SERVICES                    
000060 IRVING       STERN           MANUFACTURING SYSTEMS               
000070 EVA          PULASKI         ADMINISTRATION SYSTEMS              
000090 EILEEN       HENDERSON       OPERATIONS                          
000100 THEODORE     SPENSER         SOFTWARE SUPPORT                    
000110 VINCENZO     LUCCHESSI       SPIFFY COMPUTER SERVICE DIV.        
000120 SEAN         O'CONNELL       SPIFFY COMPUTER SERVICE DIV.        
000130 DELORES      QUINTANA        INFORMATION CENTER                  
000140 HEATHER      NICHOLLS        INFORMATION CENTER                  
000150 BRUCE        ADAMSON         MANUFACTURING SYSTEMS               
000160 ELIZABETH    PIANKA          MANUFACTURING SYSTEMS               
000170 MASATOSHI    YOSHIMURA       MANUFACTURING SYSTEMS               
000180 MARILYN      SCOUTTEN        MANUFACTURING SYSTEMS               
000190 JAMES        WALKER          MANUFACTURING SYSTEMS               
000200 DAVID        BROWN           MANUFACTURING SYSTEMS               
000210 WILLIAM      JONES           MANUFACTURING SYSTEMS               
000220 JENNIFER     LUTZ            MANUFACTURING SYSTEMS               
000230 JAMES        JEFFERSON       ADMINISTRATION SYSTEMS              
000240 SALVATORE    MARINO          ADMINISTRATION SYSTEMS              
000250 DANIEL       SMITH           ADMINISTRATION SYSTEMS              
000260 SYBIL        JOHNSON         ADMINISTRATION SYSTEMS              
000270 MARIA        PEREZ           ADMINISTRATION SYSTEMS              
000280 ETHEL        SCHNEIDER       OPERATIONS                          
000290 JOHN         PARKER          OPERATIONS                          
000300 PHILIP       SMITH           OPERATIONS                          
000310 MAUDE        SETRIGHT        OPERATIONS                          
000320 RAMLAL       MEHTA           SOFTWARE SUPPORT                    
000330 WING         LEE             SOFTWARE SUPPORT                    
000340 JASON        GOUNOT          SOFTWARE SUPPORT                    
200010 DIAN         HEMMINGER       SPIFFY COMPUTER SERVICE DIV.        
200120 GREG         ORLANDO         SPIFFY COMPUTER SERVICE DIV.        
200140 KIM          NATZ            INFORMATION CENTER                  
200170 KIYOSHI      YAMAMOTO        MANUFACTURING SYSTEMS               
200220 REBA         JOHN            MANUFACTURING SYSTEMS               
200240 ROBERT       MONTEVERDE      ADMINISTRATION SYSTEMS              
200280 EILEEN       SCHWARTZ        OPERATIONS                          
200310 MICHELLE     SPRINGER        OPERATIONS                          
200330 HELENA       WONG            SOFTWARE SUPPORT                    
200340 ROY          ALONZO          SOFTWARE SUPPORT                    
-      -            -               BRANCH OFFICE H2                    
-      -            -               BRANCH OFFICE I2                    
-      -            -               BRANCH OFFICE G2                    
-      -            -               DEVELOPMENT CENTER                  
-      -            -               BRANCH OFFICE F2                    
-      -            -               BRANCH OFFICE J2                    
99999  killkill     Huang           -

转载于:https://www.cnblogs.com/killkill/archive/2010/09/17/1829723.html

https://www.dkcj.cn/info/8202.html

vue——props的两种常用方法

vue——props的两种常用方法 1、实现父——>子的通信举例如下： 父组件 parent.vue<children :channel"object1"></children> 子组件 children.vue export default{name:"children",props:["channel"],data(){return{…

编程日记2024/05/28 09:00:00

idea导入模板

1.我的配置文件下载请点下面的连接 https://download.csdn.net/download/huyande123/10728802 先导入第二个文件，在导入第一个文件在此基础上添加了类注释和方法注释（方法注释快捷键 qtab） 参考链接 https://blog.csdn.net/qq_34581118…

编程日记2024/05/28 08:50:00

为office添加繁简体转换

为office添加繁简体转换本人所在的公司是一间港资公司，很多香港同事习惯繁体，而我们内地的同事则习惯简体，于是免不了要进行繁简体转换，这时候就要装一个office的插件来达到这样的功能，如下：1、没装插件的时…

编程日记2024/05/28 08:40:00

关闭Windows 7中的 Program Compatibility Assistant

感觉微软总喜欢把简单问题复杂化。安装几个小软件也老是弹出这样的对话框： 然后点击“What settings are applied?”，看到帮助中一段： 提示我在组策略里能够关闭这个烦人的程序兼容性助手，却没有明说，故意卖关子呢。那…

编程日记2024/05/28 08:30:00

Swift学习:自动引用计数

swift 使用自动引用计数（ARC）机制来跟踪和管理你的应用程序的内存。通常情况下，swift 内存管理机制会一直起作用，你无须自己来考虑内存的管理。ARC 会在类的实例不再被使用时，自动释放其占用的内存。然而在少数情况下…

编程日记2024/05/28 08:20:00

简单又实用的分享！SharePoint母版页引用（实战）

分享人：广州华软极简一. 前言此SharePoint 版本为2013，请注意版本号。此文以图文形式，描述了根网站及子网站引用母版页，需要注意的点已用图文形式以标明。本文适用于初学者。二. 目录 1. 前言 2. 目录 3. 如何引用母版页 4. …

编程日记2024/05/28 08:10:00

mysql 修改某字段的格式为 utf8mb4

ALTER TABLE confession MODIFY content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;#查看表中字段字符集 SHOW FULL COLUMNS FROM confession;

编程日记2024/05/28 08:00:00

TileList自动滚动指定单元格，可视部分

TileList自动滚动指定单元格，可视部分 TileList1.scrollToIndex(50)

编程日记2024/05/28 07:50:00

深入.NET DataTable

1、ADO.NET相关对象一句话介绍1)DataAdapter：DataAdapter实际是一个SQL语句集合，因为对Database的操作最终需要归结到SQL语句。2)Dataset：DataSet可以理解成若干DataTable的集合，DataSet在内存里面维护一个表集合包括表间关系。对…

编程日记2024/05/28 07:40:00

天平称球问题-转

称球问题一般会有以下3种变形： 1、N个球，其中有一个坏的，知道是轻还是重，用天平称出坏球来。 2、N个球，其中有一个坏的，不知是轻还是重，用天平称出坏球来。 3、N个球，其中有一个坏…

编程日记2024/05/28 07:30:00

Java虚拟机垃圾收集算法

1、标记-清除算法标记-清除算法分为 “标记” 和 “清除” 两个步骤：首先标记出所有需要回收的对象，然后在标记完成后统一回收所有被标记的对象，是垃圾收集算法中的最基础的收集算法。缺点：一、标记和清除两个步骤效率都不高&am…

编程日记2024/05/28 07:20:00

WMIC的用法

获得系统版本信息wmic datafile where Namec:\\windows\\explorer.exe get Manufacturer,Version,Filename获得信筒进程 wmic process list full 注意：这里的full也可以换成brief（简洁）获得硬件信息（这里以cpu为例&#xf…

编程日记2024/05/28 07:10:00

洛谷P2763 试题库问题

题目：https://www.luogu.org/problemnew/show/P2763 题目描述问题描述： 假设一个试题库中有n道试题。每道试题都标明了所属类别。同一道题可能有多个类别属性。现要从题库中抽取m 道题组成试卷。并要求试卷包含指定类型的试题。试设计一个满足要求的组卷…

编程日记2024/05/28 07:00:00

梦断代码阅读笔记03

经过几天的阅读，终于将这本书看完了，读完了整个故事，我进行了简单的总结，感觉不仅仅是在写代码与计算机或软件交流，更多的是做事行为。首先是做事得有目标。无论做什么事情都要有目标和动力，这样做起事来无…

编程日记2024/05/28 06:50:00

能让导师喜欢的学生(转自论坛)

第一，明辨是非，从善如流。研究生是未来的高级知识分子，作为国家栋梁，将来很可能为国家和社会发展献计献策，如果不能明辨是非，如何做出正确建议和决策？如果不能从善如流，如何保证自己…

编程日记2024/05/28 06:40:00

使用SpringBoot发送邮件在本地测试是好的放到服务器连接超时问题

原因原来是ECS基于安全考虑，禁用了端口25。改成465就可以发邮件了。原始配置本地可发送 #spring.mail.hostsmtp.qq.com #spring.mail.usernameqq #spring.mail.passwordpassword #spring.mail.properties.mail.smtp.starttls.enabletrue #spring.mail.prope…

编程日记2024/05/28 06:30:00

电脑中所有exe文件无法运行解决方案

电脑中所有exe文件无法运行。通过系统恢复无法解决毛病，后来才想起肯定是exe文件关联被改动，只有通过修改注册表才能改回来。要修改注册表就要运行regedit.exe文件，这也是一个exe文件，也无法运行。后来查资料找到了解决方法。现在…

编程日记2024/05/28 06:20:00

[转]后期-快速消除痘痘,完美修复MM肌肤

是面对美景，即使皮肤不好也得露个脸啊!那MM的面子问题怎么办呢?简单，咱就通过Photoshop后期处理来<?xml:namespace prefix o />给MM打造完美水嫩的肌肤!远景照片简单还原MM容颜日常拍摄的照片，很多时候是远景的拍摄，人物…

编程日记2024/05/28 06:10:00

[Android] Android MVP 架构下最简单的代码实现

Android MVP 架构下最简单的代码实现首先看图： 上图是MVP，下图是MVC MVP和MVC的区别，在于以前的View层不仅要和model层交互，还要和controller层交互。而在mvp中，view层只和presenter层交互，而model层也…

编程日记2024/05/28 06:00:00

java项目上有个红色感叹号（在project Explorer视图下）

启动项目时一直报错，检查也没问题，最后看到项目上有个红色感叹号，发现是jar包路径不对，把错误路径的jar包移除，然后再重新添加即可。转载于:https://www.cnblogs.com/sanhao/p/8059257.html

编程日记2024/05/28 05:50:00

配置jdk环境 windows

java 配置环境 JAVA_HOME D:\Program Files\Java\jdk1.8.0_181 path %JAVA_HOME%\bin;%JAVA_HOME%\jre\bin; CLASSPATH .;%JAVA_HOME%\lib;%JAVA_HOME%\lib\tools.jar

编程日记2024/05/28 05:40:00

再谈Linux修改应用程序获得root权限

我之前写过一篇关于怎样就可以使你的应用程序获得root权限运行，那个对于一些测试程序或小工程的程序时比较实用，但如果你的工程文件多达几十个甚至上百，那么这种方法就不太适用了。在Ubuntu下面，我选择适用了codelite，…

编程日记2024/05/28 05:30:00

JBPM4常见错误汇总

1.在tomcat6.0下布署错误基于JBPM4的web项目jsp页面发布出错现象： javax.servlet.ServletException: java.lang.LinkageError: loader constraint violation: when resolving interfacemethod "javax.servlet.jsp.JspApplicationContext.getExpressionFacto…

编程日记2024/05/28 05:20:00

Day 3 上午

内容提要： 动态规划数位DP 树形DP 区间DP 动态规划斐波那契数列f(0)0,f(1)1,......,f(n)f(n-1)f(n-2)0,1,1,2,3,5,8,13......他和动态规划有什么关系？首先，他有一个边界条件，就是f(0)0,f(1)1，相当于它不是从正无穷到…

编程日记2024/05/28 05:10:00

SpringBoot------添加保存时自动编译插件

1.右键Java项目2.选择“Spring Tools”3.选择“Add Boot DevTools”4.每次使用Ctrl S键时就会自动编译了实际上是在Pom.xml文件中添加了如下Java包 <dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring…

编程日记2024/05/28 05:00:00

设置PLSQ 连接oracle数据库

1 、instantclient_12_1 的设置配置文件内容 tnsnames.ora # tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools.ORCL (DESCRIPTION (ADDRESS (PROTOCOL TCP)(HOST 221.…

编程日记2024/05/28 04:50:00

《星辰变OL》估计很多人看过这书

瓜瓜小说论坛《星辰变OL》估计很多人看过这书，也估计很多人都不知道这游戏就快开始运行了。本人2009-2010最期待的游戏了。咩羊大大你千万注意下，这游戏一有封测，内测一类。一定要给我留个号。下面看视频。一定要给我留号啊~咩羊&#xf…

编程日记2024/05/28 04:40:00

Ubuntu16.04 搭建nexus 私服学习步骤以及安装maven和git

1、下载安装maven wget https://www-us.apache.org/dist/maven/maven-3/3.6.0/binaries/apache-maven-3.6.0-bin.tar.gz 1、创建maven仓库位置 2、修改setting.xml文件添加东西如下 export M2_HOME/software/maven/apache-maven-3.6.0 export CLASSPATH$CLASSPATH:$M2_H…

编程日记2024/05/28 04:30:00

Asp.net(C#)给图片加上水印效果(转自园上的Seven Eleven)

Asp.net(C#)给图片加上水印效果 private void Btn_Upload_Click(object sender, System.EventArgs e) { if(UploadFile.PostedFile.FileName.Trim()!"") { //上传文件 string extension Path.GetExten…

编程日记2024/05/28 04:20:00

pip install失败报错解决方案

cmd pip install 某些包时报错 pip install Consider using the --user option or check the permissions. 只需要pip install --user package就可以解决转载于:https://www.cnblogs.com/webRobot/p/10799270.html

编程日记2024/05/28 04:10:00

相关文章：