mysql实验二

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| net1               |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)


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


mysql> use  sye;
Database changed
mysql> create table student (
    -> sno int(20),
    -> sname varchar(20),
    -> ssex varchar(20),
    -> sage int(20),
    -> sdept varchar(20),
    -> address varchar(20)
    -> );
Query OK, 0 rows affected (0.11 sec)


mysql> create table sc (
    -> sno int(20),
    -> cno int(20),
    -> grade int(20)
    -> );
Query OK, 0 rows affected (0.05 sec)


mysql> create table course (
    -> cno int(20),
    -> cname varchar(20),
    -> cpno int(20),
    -> credit varchar(20)
    -> );
Query OK, 0 rows affected (0.05 sec)


mysql> alter table student ADD PRIMARY KEY(sno);（ primary key就是 主键 的意思。每张表只允许有一个 主键 ，设置为 主键 的字段不得为空也不允许有重复值）：STUDENT表中SNO设为非空和唯一
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> alter table student add sbieth varchar(20);：STUDENT表中增加一个字段SBIRTH
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> alter table student drop column address;：删除STUDENT表中ADDRESS字段
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> alter table course ADD PRIMARY KEY(cno);：COURSE表中CNO字段设为非空和唯一
Query OK, 0 rows affected (0.08 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> create table ss (     ：重新定义一个简单表，然后用SQL语言DROP语句删除该表结构
    -> sname varchar(20)
    -> );
Query OK, 0 rows affected (0.04 sec)


mysql> drop table ss;
Query OK, 0 rows affected (0.01 sec)


mysql> create index student_idx on student(sname desc);：用SQL语言CREATE INDEX语句定义表STUDENT的SNAME字段的降序索引
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> create index sc_idx on sc(grade asc);：用SQL语言CREATE INDEX语句定义表SC的GRADE字段的升序索引
Query OK, 0 rows affected (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql> drop index sc_idx on sc;：用SQL语言DROP语句删除索引
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0


mysql>