Java - 数据库(mysql -> oracle - 1)

07.22笔记

• mysql

  • CREATE USER ‘username’@’host’ [IDENTIFIED BY ‘PASSWORD’]

  • 授权 (以下这句话没提到的on by之类的是固定语法)

    • privileges(全部权限,可以选择insert, select等),星.星(库名.表名) root@localhost(帐户名@操作地址), ‘root’(密码)
    • GRANT all privileges ON 星.星 TO root@localhost IDENTIFIELD BY ‘root’;

  • 刷新权限

    • flush privileges;

  • 删除权限

    • revoke all privileges on 星.星 from root@localhost;

  • 改密码

    • set password for root@localhost = password(‘newPwd’);

  • 查看用户

    • select user from mysql.user;

  • 删除用户

    • delete from user where user = ‘root’ and host = ‘localhost’;
  • 查看权限
    
    • show grants for root;

• oracle

  • sys
    
    • sys (change_on_install)
  • system
    
    • 默认密码:manager
  • scott
    
    • oracle 示范账户 默认密码:tiger

• 解锁系统scott账户和设置密码

  • alter user scott identified by qq123 account unlock;

• oracle常用的数据类型

  • 1.varchar2 字符串
  • 2.number[(p[,s])] p表示精度,s表示小数位数
  • 3.date 时间

• 创表

  • 注意点,oracle中没有if not exists, 需要自增长必须创建序列, 除了select外都要执行 commit
    
    //建表
    create table student(
    id number not null primary key,
    name varchar2(12),
    birthday date,
    score number(5,2));
    //建序列
    create sequence stu_seq start with 1
    //插数据
    insert into student (stu_seq.nextval, ‘jack’, to_date(‘2009-12-12 23:00:00’, ‘yyyy-mm-dd 24hh:mi:ss’), 80)