mysql命令行操作（二）对数据库和表插入和删除

1.创建数据库，可以看到创建了一个名为wz的数据库

mysql> create database wz;
Query OK, 1 row affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
| wz                 |
+--------------------+
5 rows in set (0.00 sec)

2.删除数据库

mysql> drop database wz;
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)

3.选择数据库，这里重新创建刚才删除的数据库wz并且进入该数据库

mysql> create database wz;
Query OK, 1 row affected (0.00 sec)

mysql> use wz;
Database changed

4.创建表，包含主键、数据库引擎、默认字符集等，每种属性都规定了数据类型，not null意思是加入记录的时候此项非空，id作为主键，自增1，即每项数据插入后，id++

mysql> create table if not exists `wz`(
    -> `id` int unsigned auto_increment,
    -> `title` varchar(100) not null,
    -> `author` varchar(40) not null,
    -> `date` date,
    -> primary key (`id`)
    -> )engine=InnoDB default charset=utf8;
Query OK, 0 rows affected (0.01 sec)

5.删除表

mysql> drop table lala;
Query OK, 0 rows affected (0.03 sec)

6.向表中插入数据，这里插入3个属性，用括号指示，属性和值中间用values隔断，id是自增的，不用设置

mysql> insert into wz(title, author, date)
    -> values
    -> ("学习","james",now());
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> select * from wz;
+----+--------+--------+------------+
| id | title  | author | date       |
+----+--------+--------+------------+
|  1 | 学习   | james  | 2018-09-13 |
+----+--------+--------+------------+
1 row in set (0.00 sec)

也可以对id进行手动设置，如下：

mysql> insert into wz(title, author, date, id)
    -> values
    -> ("工作", "mike", now(), 10);
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> select * from wz;
+----+--------+--------+------------+
| id | title  | author | date       |
+----+--------+--------+------------+
|  1 | 学习   | james  | 2018-09-13 |
| 10 | 工作   | mike   | 2018-09-13 |
+----+--------+--------+------------+
2 rows in set (0.00 sec)