- 博客(7)
- 资源 (1)
- 收藏
- 关注
RSS订阅原创 PowerDesigner配置数据源生成model教程
1.数据库>change current DBMS2.数据库>connect点击configure3.配置数据源driverClass : com.mysql.jdbc.DriverconnectionUrl : jdbc:mysql://192.168.1.97:3306/dev01?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=truejar包路径 : F:\FTP\mysql\m
2021-04-08 10:57:05
433
原创 DB2常用修改表结构SQL语句
-- 解除锁表CALL SYSPROC.ADMIN_CMD('REORG TABLE BS_DOC_CONTRACT_INFO');-- 添加字段alter table BS_CREDIT_AGREEMENT_MASTER add MARGIN_PROPORTION DECIMAL(18,6);comment on column BS_CREDIT_AGREEMENT_MASTER.MARGIN_PROPORTION is '保证金比例';--更改字段类型alter table
2021-04-08 10:00:07
946
原创 DB2自定义函数:随机不重复的UUID()
在DB2中自定义生成id的函数uuid()--uuid()CREATE FUNCTION uuid() RETURNS VARCHAR(50)LANGUAGE SQLBEGIN DECLARE RESULT VARCHAR(50) DEFAULT ''; DECLARE a VARCHAR(18) DEFAULT ''; DECLARE b VARCHAR(18) DEFAULT ''; SET a = substr(hex(DECIMAL(TO_CHAR(CURRENT_TIM
2020-08-03 11:06:20
1980
原创 eclipse启动时报错class path resource [mybatis-config.xml] cannot be opened because it does not exist
eclipse启动时报错class path resource [mybatis-config.xml] cannot be opened because it does not exist问题:eclipse启动时报错class path resource [mybatis-config.xml] cannot be opened because it does not exist解决方案:1.检查项目中mybatis-config.xml文件是否存在,检查mybatis-config.xml配
2020-08-03 11:00:34
3423
原创 MySQL与DB2语法区别
MySQL与DB2语法区别功能MySQLDB2替换NULLIFNULL(clumn,0)NVL(clumn,0)连接字段CONCAT(a,’-’,b)(a||’-’||b)前a行LIMIT aFETCH FIRST a ROWS ONLY
2020-07-29 08:49:28
1835
1
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人