随笔分类 -  技术 - 数据库

mysq误删root 找回
摘要：不小心误删了mysql.user 表里的记录，导致mysql无法登陆。怎么办？看下面。1.net stop mysql //停止mysql服务(以管理员身份,在cmd命令行下运行)2. mysqld –skip-grant-tables //启动mysql数据库不关闭以... 阅读全文
posted @ 2015-07-14 18:18 ECNB 阅读(153) 评论(0) 推荐(0)
Partition Table
摘要：what isPartition Table?Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit f... 阅读全文
posted @ 2015-06-30 18:32 ECNB 阅读(687) 评论(0) 推荐(0)
数据库 schema与catalog
摘要：数据库schema与catalog简介 按照SQL标准的解释，在SQL环境下Catalog和Schema都属于抽象概念，可以把它们理解为一个容器或者数据库对象命名空间中的一个层次，主要 用来解决命名冲突问题。从概念上说，一个数据库系统包含多个Catalog，每个Catalog又包含多个Schema... 阅读全文
posted @ 2015-06-30 18:27 ECNB 阅读(5759) 评论(0) 推荐(0)
Host variables
摘要：Host variables are data items declared in a host application program and used in bothhost language statements and embedded SQL statements. They provid... 阅读全文
posted @ 2015-06-30 18:17 ECNB 阅读(330) 评论(0) 推荐(0)
数据库系统概论 复习笔记。
摘要：大学课本复习笔记，知识点总结。2012-08-15数据模型中的 型，Type， 学号，姓名。。。。 值，Value， 0001， Ender。。。。。数据库系统的三级模式，两级映射，外模式，External Schema/Sub Schema，是用户能看得到的直接使用的。一个数据库有多个外模式，应用... 阅读全文
posted @ 2015-06-30 18:15 ECNB 阅读(1334) 评论(0) 推荐(0)
Using Publis/Subscribe function in COBOL
摘要：Publis/Subscribe function in COBOL>> Embeded Delete1. Use table SOS.ECUI.ORDERS.INSERT INTO ORDERS(ORDER_NBR,AMOUNT) VALUES(1,1111);INSERT INTO ORDERS... 阅读全文
posted @ 2015-06-30 18:05 ECNB 阅读(359) 评论(0) 推荐(0)
HP SQLMX Publish Subscribe Functionality
摘要：What Is Publish/Subscribe?Traditionally, relational database systems are passive data stores. Applications canonly retrieve and update data. Applicati... 阅读全文
posted @ 2015-06-30 17:55 ECNB 阅读(229) 评论(0) 推荐(0)
JDBC Install for OSS
摘要：JDBC Install for OSS1. The default JDBC/MX driver installation directory laction is /usr/tandem/jdbcMx/T1275h50.include:/demo //Demo programs./lib/lib... 阅读全文
posted @ 2015-06-30 17:41 ECNB 阅读(265) 评论(0) 推荐(0)
SPJs for JDBC programing and Calling it by COBOL
摘要：In this note, you will know how to access the MX table by SPJ(Stored Procedure in Java)1. Java class for stored procedure,import java.sql.*;import jav... 阅读全文
posted @ 2015-06-30 17:25 ECNB 阅读(276) 评论(0) 推荐(0)
HP Nonstop SQLMX (SPJ) Stored Procedure in Javas Getting Started
摘要：Stored Procedure in Java (SPJ)HP Nonstop SQLMX, we can code Java program and regist it as a DB Stored Procedure, and then calling it. SPJ is astored p... 阅读全文
posted @ 2015-06-30 17:24 ECNB 阅读(303) 评论(0) 推荐(0)