MySQL创建数据库与表

1.在window系统安装MySQL
2. 创建一个数据库`db_classes`
3. 创建一行表`db_hero`
4. 将四大名著中的常见人物插入这个英雄表

过程如下：

第一步：创建数据库

第二部：建表：

第三步：插入数据

第四步：结果：

1.在window系统安装MySQL

http://t.csdnimg.cn/yXUfS

过程如下：

第一步：创建数据库

mysql> create database db_classes-> default charset = utf8mb4;

第二部：建表：

mysql> use db_classes;
Database changed
mysql> show tables;
Empty set (0.00 sec)mysql> create table db_hero(-> id int not null,-> name varchar(100) not null,-> nickname varchar(100),-> age int,-> gender varchar(2),-> address varchar(100),-> weapon varchar(100),-> world varchar(100),-> types varchar(100)-> );
Query OK, 0 rows affected (0.01 sec)

第三步：插入数据

mysql> insert into db_hero values(1,"孙悟空","齐天大圣",800,"男","花果山","如意金箍棒","西游记","妖族");
Query OK, 1 row affected (0.01 sec)mysql> insert into db_hero values(2,"蜘蛛侠","皮特",20,"男","美国","蛛丝","复仇者联盟","变种人");
Query OK, 1 row affected (0.00 sec)mysql> insert into db_hero values(3,"李逵","黑旋风",30,"男","沂州","两柄板斧","水浒传","人类");
Query OK, 1 row affected (0.01 sec)mysql> insert into db_hero values(4,"赵云","常山赵子龙",27,"男","常山","涯角枪","三国演义","人类");
Query OK, 1 row affected (0.01 sec)mysql>  insert into db_hero values(5,"唐僧","金蝉子",25,"男","东土大唐","法杖","西游记","人类");
Query OK, 1 row affected (0.00 sec)mysql> insert into db_hero values(6,"紫霞仙子","盘丝大仙",500,"女","盘丝洞","紫青宝剑","西游计","神仙");
Query OK, 1 row affected (0.00 sec)