30 lines
1.2 KiB
Markdown
30 lines
1.2 KiB
Markdown
|
>https://gitee.com/rainsuper/RuoYi-Vue-Super/wikis/pages?sort_id=5953970&doc_id=2965484
|
||
|
|
|
||
|
|
>https://gitee.com/tony2y/RuoYi-flowable
|
||
|
|
|
||
|
|
# Docker 安装 达梦 8
|
||
|
|
> https://eco.dameng.com/document/dm/zh-cn/start/dm-install-docker.html
|
||
|
|
|
||
|
|
docker run -d -p 30236:5236 --restart=always --name dm8_test --privileged=true -e PAGE_SIZE=16 -e LD_LIBRARY_PATH=/opt/dmdbms/bin -e EXTENT_SIZE=32 -e BLANK_PAD_MODE=1 -e LOG_SIZE=1024 -e UNICODE_FLAG=1 -e LENGTH_IN_CHAR=1 -e INSTANCE_NAME=dm8_test -v /data/dm8_test:/opt/dmdbms/data dm8_single:dm8_20230808_rev197096_x86_rh6_64
|
||
|
|
|
||
|
|
|
||
|
|
### 驱动
|
||
|
|
> F:\JAVA_Hibernate_lib_dameng\DmJdbcDriver18.jar
|
||
|
|
|
||
|
|
### 修改字段
|
||
|
|
```
|
||
|
|
### 批量修改数据库表字段长度
|
||
|
|
select concat('alter table ',OWNER,'.',TABLE_NAME,' MODIFY ',COLUMN_NAME,' VARCHAR(1000)',';')
|
||
|
|
from SYS.DBA_TAB_COLUMNS
|
||
|
|
WHERE OWNER= '模式' and DATA_LENGTH = '字段大小，自行更改'
|
||
|
|
and COLUMN_NAME = '字段名，自行更改'
|
||
|
|
|
||
|
|
|
||
|
|
### 批量修改数据库表字段大小写
|
||
|
|
select CONCAT('alter table ',OWNER,'.',TABLE_NAME,' rename column ',CONCAT('"',COLUMN_NAME,'"'),' TO "',UPPER(COLUMN_NAME),'";')
|
||
|
|
from SYS.DBA_TAB_COLUMNS
|
||
|
|
where OWNER= '模式' and DATA_LENGTH = '字段大小，自行更改'
|
||
|
|
and COLUMN_NAME = '字段名，自行更改'
|
||
|
|
and COLUMN_NAME = UPPER(COLUMN_NAME)
|
||
|
|
|
||
|
|
```
|