qq_38841868的博客

一、更新A表中的数据，从B表中查询与A表对应的数据1、update T1 set T1.fmoney =(select T2.fmoney from t2 where T2.fname =T1.fname) where exists (select 1 from t2 where T2.fname = T1.name)2、B表中name存在重复数据merge into tias_workload Wusing (select S.* from (select P.*,row_numberr()

Hibernate的使用：导包配置hibernate.cfg.xml文件<hibernate-configuration> <session-factory name="foo"> <property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</p...

Mybatis环境配置mybatis的jar包下载地址：https://github.com/mybatis/mybatis-3/releasesmybatis和Spring整合jar包下载地址：https://github.com/mybatis/spring/releases配置mybatis全局配置文件 <?xml version="1.0" encoding="UT...

Oracle：常用命令： sqlplus system/521314@192.168.3.12:1521/orcl; //远程登录数据库 lsnrctl start、stop; //启动和停止监听 host cls; //清屏 show user; //显示当前用户 select *from tab; //当前用户下的表 desc table; //查看表的结构 ...