第二次作业

mysql> create database zoo
    -> ;
Query OK, 1 row affected (0.01 sec)

mysql> alter database zoo character set gbk;
Query OK, 1 row affected (0.01 sec)

mysql> use zoo
Database changed
mysql> show create database zoo;
+----------+------------------------------------------------------------------------------------------------+
| Database | Create Database                                                                                |
+----------+------------------------------------------------------------------------------------------------+
| zoo      | CREATE DATABASE `zoo` /*!40100 DEFAULT CHARACTER SET gbk */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+----------+------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> drop database zoo;
Query OK, 0 rows affected (0.01 sec)

mysql> create database db_system
    -> ;
Query OK, 1 row affected (0.02 sec)
mysql> use db_system
Database changed
mysql> create table user(
    -> id int primary key auto_increment comment 'id',
    -> name char(16) not null comment '姓名',
    -> gender enum('M','F') not null comment '性别',
    -> birthday date comment '生日',
    -> entry_date date not null comment '入职时间',
    -> job char(16) not null comment '职位'
    -> );
Query OK, 0 rows affected (0.03 sec)

mysql> create table salary(
    -> id int primary key auto_increment comment 'id',
    -> userid int not null comment '用户id',
    -> baseSalary decimal(10, 2) not null comment '基本工资',
    -> month int not null comment '月份',
    -> allowances decimal(10, 0) not null default 0 comment '补贴',
    -> constraint fk_user_id foreign key (userid) references db_system.user
(id)
    -> );

mysql> alter table user add image blob(255)
    -> ;
Query OK, 0 rows affected (0.03 sec)

mysql> alter table user modify job char(60)
    -> ;
Query OK, 0 rows affected (0.05 sec)

mysql> alter table user drop gender;
Query OK, 0 rows affected (0.02 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> rename table salary to usersalary;
Query OK, 0 rows affected (0.02 sec)

mysql> alter table user default charset=utf8;

mysql> alter table user change name username char(16);
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0