MySQL-创建英雄表

妤......

已于 2024-01-13 11:17:50 修改

阅读量378

点赞数 10

文章标签：数据库 mysql

于 2024-01-13 01:21:00 首次发布

本文链接：https://blog.csdn.net/2301_81538927/article/details/135563158

版权

1.查看数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| homework           |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| test               |
+--------------------+
7 rows in set (0.01 sec)

2. 创建数据库

mysql> create database hero;
Query OK, 1 row affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| hero               |
| homework           |
| information_schema |
| mysql              |
| performance_schema |
| sakila             |
| sys                |
| test               |
+--------------------+
8 rows in set (0.00 sec)

mysql> use hero;
Database changed

mysql> select database();
+------------+
| database() |
+------------+
| hero       |
+------------+
1 row in set (0.00 sec)

3. 创建数据表

mysql> create table hero
    -> (name varchar(25),
    -> nickname varchar(25),
    -> arrangement varchar(25),
    -> email char(30),
    -> tel smallint(30));
Query OK, 0 rows affected, 3 warnings (0.03 sec)

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

4.查询数据表

mysql> select * from hero;
Empty set (0.01 sec)

mysql> desc hero;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| name        | varchar(25) | YES  |     | NULL    |       |
| nickname    | varchar(25) | YES  |     | NULL    |       |
| arrangement | varchar(25) | YES  |     | NULL    |       |
| email       | char(30)    | YES  |     | NULL    |       |
| tel         | smallint    | YES  |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

5.添加数据

mysql> insert into hero(name,nickname,arrangement,email,tel) value("宋江","及时雨","第一名","songjiang.com",12318);
Query OK, 1 row affected (0.00 sec)

mysql> insert into hero(name,nickname,arrangement,email,tel) value("吴用","智多星","第三名","wuyong.com",12396);
Query OK, 1 row affected (0.01 sec)

mysql> insert into hero(name,nickname,arrangement,email,tel) value("林冲","豹子头","第六名","linchong.com",12348);
Query OK, 1 row affected (0.01 sec)

mysql> insert into hero(name,nickname,arrangement,email,tel) value("鲁智深","花和尚","第十三名","luzhishen.com",12314);
Query OK, 1 row affected (0.01 sec)

mysql> insert into hero(name,nickname,arrangement,email,tel) value("李逵","黑旋风","第二十二名","likui.com",12349);
Query OK, 1 row affected (0.00 sec)

6.查询hero数据表

mysql> select * from hero;
+--------+----------+-------------+---------------+-------+
| name   | nickname | arrangement | email         | tel   |
+--------+----------+-------------+---------------+-------+
| 宋江   | 及时雨   | 第一名      | songjiang.com | 12318 |
| 吴用   | 智多星   | 第三名      | wuyong.com    | 12396 |
| 林冲   | 豹子头   | 第六名      | linchong.com  | 12348 |
| 鲁智深 | 花和尚   | 第十三名    | luzhishen.com | 12314 |
| 李逵   | 黑旋风   | 第二十二名  | likui.com     | 12349 |
+--------+----------+-------------+---------------+-------+
5 rows in set (0.00 sec)