数据库
文章平均质量分 59
꧁༺摩༒西༻꧂
这个作者很懒,什么都没留下…
展开
-
SQL Server 2019安装
win10安装sql server2019原创 2022-09-20 20:48:48 · 461 阅读 · 0 评论 -
Mac安装redis、mysql、nginx
安装redisDownload | Redis拷贝解压编译测试 make test安装 make install启动服务src/redis-server登录redisredis-cli -h 127.0.0.1 -p 6379原创 2022-05-06 22:33:56 · 782 阅读 · 0 评论 -
Navicat、PDMan、DBeaver三者ER图比较
NavicatPDManDBeaver原创 2021-04-06 15:23:35 · 4768 阅读 · 2 评论 -
Explain执行计划
简介当Explain与SQL语句一起使用时,MySQL会显示来自优化器关于SQL执行的信息。/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50731 Source Host : localhost:3306 Source Schema : test Ta...原创 2021-01-02 17:37:48 · 180 阅读 · 0 评论 -
docker-compose安装Mysql、Oracle、MongoDB
docker-compose.ymlversion: '3'services: mysql5: image: mysql:5.7 container_name: mysql5 environment: - "MYSQL_ROOT_PASSWORD=123456" ports: - 3306:3306 oracle11g: image: registry.cn-hangzhou.aliyuncs.com/helowin/oracl原创 2020-12-05 11:37:10 · 184 阅读 · 0 评论 -
Mac使用Docker安装Mysql和Oracle
安装dockerbrew cask install docker镜像加速{ "registry-mirrors":[ "https://hub-mirror.c.163.com/" ], "features": { "buildkit": true }, "experimental": false}查找镜像docker search mysql拉取 MySQL 镜像docker pull mysql:latest查看本原创 2020-10-17 20:29:03 · 341 阅读 · 0 评论 -
Navicat Premium配置Oracle11
管理员登录sys as sysdba创建表空间create TABLESPACE PREPOLICY logging DATAFILE 'D:\app\Administrator\oradata\orcl\PREPOLICY_LOCAL.DBF' SIZE 500M;创建用户create user prepolicy profile default identified by prepolicy account unlock default tablespace PREPOLICY te原创 2020-10-11 00:40:01 · 361 阅读 · 0 评论 -
SQL Server触发器调用java接口
创建表USE [test]GO/****** Object: Table [dbo].[T_BD_SUPPLIER] Script Date: 2020/5/19 15:03:17 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[T_BD_SUPPLIER]( [FSUPPLIERID] [int] NOT NULL, [FAUDITDATE] [datetime] NULL,原创 2020-05-19 15:28:47 · 1398 阅读 · 0 评论 -
SQL Server 2016安装
下载SQLServer2016SP2-FullSlipstream-x64-CHS.iso安装安装规则产品密钥准备安装许可条款同意安装Miscrosoft R Open功能选择完成原创 2019-03-21 09:51:20 · 5282 阅读 · 0 评论 -
bat启动和停止oracle、mysql服务,bat执行mysql脚本
目录bat启动oraclebat停止oraclebat启动pdborclbat启动mysqlbat停止mysqlbat执行mysql脚本bat执行SQL Server脚本bat启动oracle@echo offrem Copyright (c) 2019 Moses and/or its affiliates.net start OracleService...原创 2019-02-15 16:06:29 · 982 阅读 · 0 评论 -
mysql-8.0.11-winx64环境搭建
1.搜索mysql2.下载,点击https://www.mysql.com/downloads/3.解压后进入bin目录D:\program\mysql-8.0.11-winx64\bin4.配置 my.imi文件,D:\program\mysql-8.0.11-winx64[mysqld]# 设置...原创 2018-04-28 20:14:53 · 12401 阅读 · 0 评论 -
oracle创建和调试存储过程
目录一、添加存储过程二、执行调试三、附录-建表语句一、添加存储过程create or replace procedure add_emp(empno number, ename varchar2, job va...原创 2019-02-19 10:42:44 · 430 阅读 · 0 评论 -
Oracle归档开启、关闭及清理,添加定时任务
目录一、闪回区耗尽,导致无法启动二、删除归档日志三、oracle重启四、更改和查看归档五、Oracle开启和关闭归档六、定时清理归档一、闪回区耗尽,导致无法启动[oracle@ZCB1ZNFS01 ~]$ sqlplusSQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 18 17:59:28 2019Copyr...原创 2019-02-18 19:14:22 · 735 阅读 · 0 评论 -
oracle12开启pdborcl
C:\Users\ShaoRongFan>sqlplus sys as sysdba alter session set container=pdborcl; startup命令行导出导入数据exp xxx/xxx@PDBORCL file=d:/AIIB.dmpimp xxx/xxx@PDBORCL file=d:/AIIB.dmp...原创 2018-09-21 22:43:06 · 3101 阅读 · 0 评论 -
PowerDesigner16.5导出Oracle11g数据表结构
1.下载PowerDesigner165.zip,解压安装PowerDesigner165_Evaluation.1428562995.exe,pdflm16.dll替换Sybase\PowerDesigner 16下该文件破解 链接: https://pan.baidu.com/s/1K_Idg6qYEoUyPZ1Hsq61DA 密码: xbqj2.下载instantclient-bas...原创 2018-06-29 22:43:35 · 2365 阅读 · 0 评论 -
PLSQL Developer执行sql没有响应,Oracle表被锁定
--oracle中查看表是否被锁SELECT /*+ rule*/ a.sid, b.owner, object_name, object_type FROM v$lock a, all_objects b WHERE TYPE = 'TM' and a.id1 = b.object_id;--查到被锁的表杀掉 SELECT sid, serial# FROM v原创 2013-01-04 11:44:06 · 1307 阅读 · 0 评论