mysql> show databases; +---------------------+ | Database | +---------------------+ | information_schema | | fairykunkundatabase | | mysql | | test | | wbj22011 | +---------------------+ 5 rows in set (0.00 sec) mysql> use fairykunkundatabase; Database changed4. 建表
基础知识
编辑规范、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 表明；
这里我就不演示了，恢复比较麻烦
