随笔分类 -  Database

摘要：CREATE TABLE IF NOT EXISTS `RBAC_GRANT` ( `GRANT_ID` int(11) NOT NULL PRIMARY KEY default '0' COMMENT '授权编号', `PERMISSION_ID` int(11) default NULL COMMENT '权限编号', `ROLE_ID` int(11) default NULL COMMENT '角色编号', `ACTION` int(11) default NULL COMMENT '拥护的操作') COM 阅读全文

摘要：-- Create tablecreate table RBAC_GRANT( GRANT_ID INTEGER not null, PERMISSION_ID INTEGER, ROLE_ID INTEGER, ACTION VARCHAR2(500))-- Add comments to the columns comment on column RBAC_GRANT.GRANT_ID is '编号';comment on column RBAC_GRANT.PERMISSION_ID is '权限编号';comment on column ... 阅读全文

摘要：-- Create tablecreate table QQ_SERVICE( ID INTEGER not null, NAME VARCHAR2(30 CHAR), QQ VARCHAR2(20 CHAR), CREATE_TIME DATE default SYSDATE, UPDATE_TIME DATE null, TYPE_ID INTEGER not null)-- Add comments to the table comment on table QQ_SERVICE is 'QQ客服表';-- Add ... 阅读全文

摘要：-- Create tablecreate table DISTRICT_CODE( DISTRICT_ID INTEGER PRIMARY KEY NOT NULL, NAME VARCHAR2(30 CHAR) not null, PARENT_DISTRICT_ID INTEGER default 0 not null, PROVINCE_ID INTEGER default 0 not null, PROVINCE_NAME VARCHAR2(30 CHAR), CITY_ID I... 阅读全文

摘要：-- Create tablecreate table COMMON_TYPE( TYPE_ID INTEGER PRIMARY KEY NOT NULL, TYPE_CODE VARCHAR2(40) not null, TYPE_NAME VARCHAR2(40 CHAR) not null, NAME VARCHAR2(40 CHAR), PARENT_ID INTEGER default 0 not null, DESCRIPTION VARCHAR2(100 CHAR), GRADE INTEGER defa... 阅读全文

摘要：1。停止mysql服务。//打开命令行窗口，停止mysql服务：Netstopmysql2。启动mysql，一般到mysql的安装路径，找到mysqld-nt.exe执行：mysqld-nt--skip-grant-tables当前窗口将会停止。3。另外打开一个命令行窗口，进入MYSQL的安装位置下BIN目录，运行mysql4。输入如下命令：>usemysql>updateusersetpassword=password("new_password")whereuser="root";>flushprivileges;>exit6 阅读全文

摘要：-------------------------------------------------------------------备份与恢复-------------------------------------------------------------------备份数据库(cmd命令行下进入mysql/bin目录操作)mysqldump--default-character-set=gbk-uroot-prootbugfree>d:/bugfree080228.txt--导出数据库(在同一数据库操作时可以不设定字符)mysqldump-uroot-prootbugfree 阅读全文

摘要：use Nutshellif exists (select * from sysobjects where name = 'PurchaseItem') drop table PurchaseItemif exists (select * from sysobjects where name = 'Purchase') drop table Purchaseif exists (select *... 阅读全文

摘要：一.系统权限管理:使用sys登陆:sqlplus / as sysdba; 启动/停止默认监听:lsnrctl start/stop; 启动/停止指定监听:lsnrctl start/stop [监听名] ;查看监听器命令:lsnrctl status;启动/停止oracl实例:oradim –starup/-shutdown -sid orcl,net start/stop OracleServiceORCL;//oradim –starup/-shutdown -sid (数据库实例的sid); 二.对象权限:赋予权限时,可同时赋予给该用户多个权限,权限之间用","隔开 阅读全文

摘要：-- 以 SYSTEM 用户登录 SQL*Plus -- 创建一个自动增长的表空间WORKTBSCREATE TABLESPACE WORKTBSDATAFILE 'D:\ORACLE\ORADATA\APTECH\WORKTBS01.DBF' SIZE 10M AUTOEXTEND ON; -- 创建用户CREATE USER SANICIDENTIFIED BY SANICPWDDEFAULT... 阅读全文