创建一个kings数据库，插入数据，以及删除

创建表

#创建一个kings数据库，指定字符集utf8，设置大小写不敏感
mysql> create database if not exists kings default charset utf8 collate utf8_general_ci;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hahaha             |
| kings              |
| lol                |
| mysql              |
| performance_schema |
| test               |
| wzry               |
+--------------------+
8 rows in set (0.00 sec)
#查看创建信息
mysql> show create database kings;
+----------+----------------------------------------------------------------+
| Database | Create Database                                                |
+----------+----------------------------------------------------------------+
| kings    | CREATE DATABASE `kings` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+----------------------------------------------------------------+
1 row in set (0.00 sec)
#查看创建信息，以列表展示
mysql> show create database kings\G
*************************** 1. row ***************************
       Database: kings
Create Database: CREATE DATABASE `kings` /*!40100 DEFAULT CHARACTER SET utf8 */
1 row in set (0.00 sec)

#展示数据库名称含有k的
mysql> show databases like 'k%';
+---------------+
| Database (k%) |
+---------------+
| kings         |
+---------------+
1 row in set (0.00 sec)

创建数据表的格式：

create table tb_name(字段名，字段数据类型，字段名2，字段数据类型2，，，) 数据表的额外参数；

• 创建一个tanks表
• 注意，mysql默认关键字大小写不敏感，数据表是严格区分大小写的
  use kings;
  create table if not exists tanks(
  id int unsigned auto_increment,
  name varchar(100) not null,
  skills varchar(255) not null,
  price int not null,
  primary key(id)
  )engine=innodb default charset=utf8;

mysql> create table if not exists `tanks`(
    -> id int unsigned auto_increment,
    -> name varchar(100) not null,
    -> skills varchar(255) not null,
    -> price int not null,
    -> primary key(id)
    -> )engine=innodb default charset=utf8;
Query OK, 0 rows affected (0.02 sec)

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

#查看数据表的创建信息
mysql> show create table tanks\G
*************************** 1. row ***************************
       Table: tanks
Create Table: CREATE TABLE `tanks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `skills` varchar(255) NOT NULL,
  `price` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

#查看数据表的结构内容；
mysql> desc tanks;
+--------+------------------+------+-----+---------+----------------+
| Field  | Type             | Null | Key | Default | Extra          |
+--------+------------------+------+-----+---------+----------------+
| id     | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name   | varchar(100)     | NO   |     | NULL    |                |
| skills | varchar(255)     | NO   |     | NULL    |                |
| price  | int(11)          | NO   |     | NULL    |                |
+--------+------------------+------+-----+---------+----------------+
4 rows in set (0.01 sec)

#查看数据 
mysql> select * from tanks;
Empty set (0.00 sec)

插入数据：

#插入两条数据
mysql> insert into tanks(id,name,skills,price) values(1,'程咬金','大招回血,血量越低,伤害越高',8888),(2,'大鱼庄周','免疫所有控制','2888');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

#查询
mysql> select * from tanks;
+----+--------------+----------------------------------------+-------+
| id | name         | skills                                 | price |
+----+--------------+----------------------------------------+-------+
|  1 | 程咬金       | 大招回血,血量越低,伤害越高             |  8888 |
|  2 | 大鱼庄周     | 免疫所有控制                           |  2888 |
+----+--------------+----------------------------------------+-------+
2 rows in set (0.00 sec)

删除数据库

#创建
mysql> create database lol;
Query OK, 1 row affected (0.00 sec)
#展示
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hahaha             |
| kings              |
| lol                |
| mysql              |
| performance_schema |
| test               |
| wzry               |
+--------------------+
8 rows in set (0.00 sec)
#删除
mysql> drop database if exists lol;
Query OK, 0 rows affected (0.00 sec)
#展示
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hahaha             |
| kings              |
| mysql              |
| performance_schema |
| test               |
| wzry               |
+--------------------+
7 rows in set (0.00 sec)