1、创建数据库 mysql> create database school default character set utf8 collate utf8_general_ci; Query OK, 1 row affected (0.00 sec) 2、建表create table num(int)int varchar float bool date innodb myisam 3、修改表alter table 4、删除表drop table 5、重命名表rename table