MySQL创建数据库和表

创建数据库

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

创建表

 1.先进入想使用的数据库

use db_classes

创建表

mysql> create table db_hero(
    -> id int,
    -> name varchar(100),
    -> nickname varchar(100),
    -> age int,
    -> gender varchar(2),
    -> address varchar(10),
    -> weapon varchar(50),
    -> word varchar(20),
    -> types varchar(20)
    -> );

向表中插入数据

mysql> insert into db_hero values(1,"孙悟空","齐天大圣",8000,"男","花果 ","金箍棒","西游世界","妖族");

mysql> insert into db_hero values(2,"关羽","武圣",60,"男","运城","青龙偃月刀","三国世界","人族");

mysql> insert into db_hero values(3,"林冲","豹子头",55,"男","开封","花枪","水浒世界","人族");

mysql> insert into db_hero values(4,"林黛玉","林妹妹",17,"女","苏州","垂杨柳","红楼梦世界","人族");