MySQL作业一

一、创建数据库

#创建数据库
mysql> create database db_ck;
Query OK, 1 row affected (0.01 sec)

mysql> show databases like "db_%";
+-----------------+
| Database (db_%) |
+-----------------+
| db_ck           |
| db_system       |
+-----------------+
2 rows in set (0.03 sec)

二、创建表

#创建表
mysql> use db_ck
Database changed

mysql> create table t_hero(
    -> id int,
    -> name varchar(255),
    -> age int,
    -> gender char(2),
    -> address varchar(255),
    -> work varchar(50)
    -> );
Query OK, 0 rows affected (0.02 sec)

mysql> desc t_hero;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| id      | int          | YES  |     | NULL    |       |
| name    | varchar(255) | YES  |     | NULL    |       |
| age     | int          | YES  |     | NULL    |       |
| gender  | char(2)      | YES  |     | NULL    |       |
| address | varchar(255) | YES  |     | NULL    |       |
| work    | varchar(50)  | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
6 rows in set (0.01 sec)

三、插入数据

#插入数据
mysql> insert into t_hero values(1,"贾宝玉",20,"男","贾府怡红院","贾府公子");
Query OK, 1 row affected (0.01 sec)

mysql> insert into t_hero values(2,"林黛玉",17,"女","贾府潇湘馆","千金小姐");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(3,"薛宝钗",21,"女","贾府蘅芜苑","贾宝玉的妻子");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(4,"王熙凤",25,"女","贾府贾琏院","贾府管家");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(5,"孙悟空",1000,"男","花果山","齐天大圣");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(6,"唐僧",20,"男","东土大唐","旃檀功德佛");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(7,"猪八戒",1000,"男","福陵山云栈洞","天蓬元帅");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(8,"沙僧",1000,"男","流沙河","卷帘大将");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(9,"宋江",30,"男","郓城宋家村","梁山寨主");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(10,"林冲",30,"男","东京","梁山马军五虎 将之一");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(11,"武松",25,"男","清河县","梁山步军头 领");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(12,"鲁智深",30,"男","五台山","梁山步军 头领");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(13,"刘备",63,"男","涿郡涿县","蜀汉开国 皇帝");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(14,"诸葛亮",54,"男","琅琊阳都","蜀汉丞 相");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(15,"曹操",66,"男","沛国谯县","东汉丞相");
Query OK, 1 row affected (0.00 sec)

mysql> insert into t_hero values(16,"关羽",60,"男","河东郡解县","蜀汉前 将军");
Query OK, 1 row affected (0.00 sec)

mysql> select * from t_hero;
+------+--------+------+--------+--------------+--------------------+
| id   | name   | age  | gender | address      | work               |
+------+--------+------+--------+--------------+--------------------+
|    1 | 贾宝玉 |   20 | 男     | 贾府怡红院   | 贾府公子           |
|    2 | 林黛玉 |   17 | 女     | 贾府潇湘馆   | 千金小姐           |
|    3 | 薛宝钗 |   21 | 女     | 贾府蘅芜苑   | 贾宝玉的妻子       |
|    4 | 王熙凤 |   25 | 女     | 贾府贾琏院   | 贾府管家           |
|    5 | 孙悟空 | 1000 | 男     | 花果山       | 齐天大圣           |
|    6 | 唐僧   |   20 | 男     | 东土大唐     | 旃檀功德佛         |
|    7 | 猪八戒 | 1000 | 男     | 福陵山云栈洞 | 天蓬元帅           |
|    8 | 沙僧   | 1000 | 男     | 流沙河       | 卷帘大将           |
|    9 | 宋江   |   30 | 男     | 郓城宋家村   | 梁山寨主           |
|   10 | 林冲   |   30 | 男     | 东京         | 梁山马军五虎将之一 |
|   11 | 武松   |   25 | 男     | 清河县       | 梁山步军头领       |
|   12 | 鲁智深 |   30 | 男     | 五台山       | 梁山步军头领       |
|   13 | 刘备   |   63 | 男     | 涿郡涿县     | 蜀汉开国皇帝       |
|   14 | 诸葛亮 |   54 | 男     | 琅琊阳都     | 蜀汉丞相           |
|   15 | 曹操   |   66 | 男     | 沛国谯县     | 东汉丞相           |
|   16 | 关羽   |   60 | 男     | 河东郡解县   | 蜀汉前将军         |
+------+--------+------+--------+--------------+--------------------+
16 rows in set (0.00 sec)