MySQL创建数据库表student

落日映苍穹つ 2022-10-22 04:13 249阅读 0赞

# MySQL创建数据库表student #

1，创建数据库

create database mydb；

![20210403171626361.png][]

2，查看所有数据库

show databases;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70][]

3，使用数据库

use mydb;

![20210403171659270.png][]

4，创建数据库表student

create table student(sno int(6),name varchar(12),sex char(2),age int (2),enterdate date,classname varchar(12),email varchar(20));

![20210403171739186.png][]

5，查看表的结构

desc student；

说明：desc：description描述的意思

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 1][]

6，查看完整的建表语句

show create table student；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 2][]

7，查看表的数据

select \* from student；

![20210403171834154.png][]

[20210403171626361.png]: /images/20221022/e2705184fe8643d0a213bbcb8b0b6743.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70]: /images/20221022/719642c03b6f4f88a19e68ef91943707.png
[20210403171659270.png]: /images/20221022/d10c31b9845946948e0c857c6ed1b4e9.png
[20210403171739186.png]: /images/20221022/da4272f199dd43f6893e962b39d71c17.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 1]: /images/20221022/1765c47267d147869be524069ffee18d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ4NzU5NjY0_size_16_color_FFFFFF_t_70 2]: /images/20221022/120a00422b9249689edcaf4f90f545d1.png
[20210403171834154.png]: /images/20221022/35340bf639d7417ea17ac97a35e5bdef.png