mysql建表

1. 登录数据库

2. 创建数据库

3. 选择数据库

mysql> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| fairykunkundatabase |
| mysql               |
| test                |
| wbj22011            |
+---------------------+
5 rows in set (0.00 sec)

mysql> use fairykunkundatabase;
Database changed

4. 建表

基础知识

编辑规范、mysql的数据类型

mysql> use fairykunkundatabase;
Database changed
mysql> create table t_student(
    -> t_studentnumber varchar(4),
    -> t_name varchar(20),
    -> t_birthday date,
    -> t_height int
    -> )engine=Innodb;
Query OK, 0 rows affected (0.01 sec)

5. 检查建表是否成功

mysql> show tables;
+-------------------------------+
| Tables_in_fairykunkundatabase |
+-------------------------------+
| t_student                     |
+-------------------------------+
1 row in set (0.00 sec)

6. 查看表格的表述信息

mysql> desc t_student;
+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| t_studentnumber | varchar(4)  | YES  |     | NULL    |       |
| t_name          | varchar(20) | YES  |     | NULL    |       |
| t_birthday      | date        | YES  |     | NULL    |       |
| t_height        | int(11)     | YES  |     | NULL    |       |
+-----------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

说明：

删除表格的语法跟删除数据库的语法类似

drop table 表明；

这里我就不演示了，恢复比较麻烦