databases

show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sakila             |

| sys                |

| world              |

+--------------------+

mysql> create database stusys;

Query OK, 1 row affected (0.01 sec)

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sakila             |

| stusys             |

| sys                |

| world              |

+--------------------+

mysql> use stusys;

Database changed

mysql> alter database stusys

    -> default character set gb2312

    -> default collate gb2312_chinese_ci;

Query OK, 1 row affected (0.01 sec)

mysql> drop database stusys;

Query OK, 0 rows affected (0.01 sec)

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| sakila             |

| sys                |

| world              |

+--------------------+

6 rows in set (0.00 sec)

mysql> use stusys;

Database changed

mysql> create table student

    -> (

    ->      sno char(6) not null primary key,

    ->      sname char(8) not null,

    ->      ssex char(2) not null default '男',

    ->      sbirthday date not null,

    ->      speciality char(12) null,

    ->      tc tinyint null

    -> );

Query OK, 0 rows affected (0.02 sec)