2020/10/29 刘一辰的JAVA随笔

今日目标：Mysql实验5

实验内容：

查看创建的表以及架构

SHOW TABLES;

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

| Tables_in_selecttest |

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

| course               |

| score                |

| student              |

| teacher              |

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

 

查看student表结构    DESCRIBE student;

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

| Field      | Type        | Null | Key | Default | Extra |

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

| s_no       | varchar(20) | NO   | PRI | NULL    |       |

| s_name     | varchar(20) | NO   |     | NULL    |       |

| s_sex      | varchar(10) | NO   |     | NULL    |       |

| s_birthday | datetime    | YES  |     | NULL    |       |

| s_class    | varchar(20) | YES  |     | NULL    |       |

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

 

查看teacher表结构    DESCRIBE teacher;

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

| Field      | Type        | Null | Key | Default | Extra |

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

| t_no       | varchar(20) | NO   | PRI | NULL    |       |

| t_name     | varchar(20) | NO   |     | NULL    |       |

| t_sex      | varchar(20) | NO   |     | NULL    |       |

| t_birthday | datetime    | YES  |     | NULL    |       |

| t_rof      | varchar(20) | NO   |     | NULL    |       |

| t_depart   | varchar(20) | NO   |     | NULL    |       |

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

 

查看course表结构    DESCRIBE course;

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

| Field  | Type        | Null | Key | Default | Extra |

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

| c_no   | varchar(20) | NO   | PRI | NULL    |       |

| c_name | varchar(20) | NO   |     | NULL    |       |

| t_no   | varchar(20) | NO   | MUL | NULL    |       |

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

 

查看score表结构    DESCRIBE score;

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

| Field     | Type          | Null | Key | Default | Extra |

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

| s_no      | varchar(20)   | NO   | PRI | NULL    |       |

| c_no      | varchar(20)   | NO   | MUL | NULL    |       |

| sc_degree | decimal(10,0) | YES  |     | NULL    |       |

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