数据库day6-练习

最新推荐文章于 2024-10-08 17:39:57 发布

重庆城科李立川

最新推荐文章于 2024-10-08 17:39:57 发布

阅读量61

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/lilichuan132/article/details/131838407

版权

该文详细展示了如何使用mysqldump命令对MySQL数据库进行不同级别的备份和还原，包括单个表和整个数据库，并涉及了外键处理。同时，文章也涵盖了对数据库表结构的修改，如添加、删除字段和索引，以及创建和删除视图的操作。

摘要由CSDN通过智能技术生成

一、备份与还原


	/***************************样例表***************************/
	CREATE DATABASE booksDB;
	use booksDB;

	CREATE TABLE books
	(
	  bk_id  INT NOT NULL PRIMARY KEY,
	  bk_title VARCHAR(50) NOT NULL,
	  copyright YEAR NOT NULL
	);
	INSERT INTO books
	VALUES (11078, 'Learning MySQL', 2010),
	(11033, 'Study Html', 2011),
	(11035, 'How to use php', 2003),
	(11072, 'Teach youself javascript', 2005),
	(11028, 'Learing C++', 2005),
	(11069, 'MySQL professional', 2009),
	(11026, 'Guide to MySQL 5.5', 2008),
	(11041, 'Inside VC++', 2011);

	CREATE TABLE authors
	(
	  auth_id     INT NOT NULL PRIMARY KEY,
	  auth_name  VARCHAR(20),
	 auth_gender CHAR(1)
	);
	INSERT INTO authors  
	VALUES (1001, 'WriterX' ,'f'),
	(1002, 'WriterA' ,'f'),
	(1003, 'WriterB' ,'m'),
	(1004, 'WriterC' ,'f'),
	(1011, 'WriterD' ,'f'),
	(1012, 'WriterE' ,'m'),
	(1013, 'WriterF' ,'m'),
	(1014, 'WriterG' ,'f'),
	(1015, 'WriterH' ,'f');

	CREATE TABLE authorbook
	(
	  auth_id  INT NOT NULL,
	  bk_id   INT NOT NULL,
	  PRIMARY KEY (auth_id, bk_id),
	  FOREIGN KEY (auth_id) REFERENCES authors (auth_id),
	  FOREIGN KEY (bk_id) REFERENCES books (bk_id)
	);

	INSERT INTO authorbook
	VALUES (1001, 11033), (1002, 11035), (1003, 11072), (1004, 11028),
	(1011, 11078), (1012, 11026), (1012, 11041), (1014, 11069);

	/***************************样例表***************************/
	
	1、使用mysqldump命令备份数据库中的所有表
	2、备份booksDB数据库中的books表
	3、使用mysqldump备份booksDB和test数据库
	4、使用mysqldump备份服务器中的所有数据库
	5、使用mysql命令还原第二题导出的book表
	6、进入数据库使用source命令还原第二题导出的book表

//按要求创建数据表并插入数据
mysql> CREATE DATABASE booksDB;
Query OK, 1 row affected (0.00 sec)
mysql> use booksDB;
Database changed
mysql> CREATE TABLE books
    -> (
    ->   bk_id  INT NOT NULL PRIMARY KEY,
    ->   bk_title VARCHAR(50) NOT NULL,
    ->   copyright YEAR NOT NULL
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> desc books;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| bk_id     | int(11)     | NO   | PRI | NULL    |       |
| bk_title  | varchar(50) | NO   |     | NULL    |       |
| copyright | year(4)     | NO   |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> INSERT INTO books
    -> VALUES (11078, 'Learning MySQL', 2010),
    -> (11033, 'Study Html', 2011),
    -> (11035, 'How to use php', 2003),
    -> (11072, 'Teach youself javascript', 2005),
    -> (11028, 'Learing C++', 2005),
    -> (11069, 'MySQL professional', 2009),
    -> (11026, 'Guide to MySQL 5.5', 2008),
    -> (11041, 'Inside VC++', 2011);
Query OK, 8 rows affected (0.00 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> select * from books;
+-------+--------------------------+-----------+
| bk_id | bk_title                 | copyright |
+-------+--------------------------+-----------+
| 11026 | Guide to MySQL 5.5       |      2008 |
| 11028 | Learing C++              |      2005 |
| 11033 | Study Html               |      2011 |
| 11035 | How to use php           |      2003 |
| 11041 | Inside VC++              |      2011 |
| 11069 | MySQL professional       |      2009 |
| 11072 | Teach youself javascript |      2005 |
| 11078 | Learning MySQL           |      2010 |
+-------+--------------------------+-----------+
8 rows in set (0.00 sec)

mysql> CREATE TABLE authors
    -> (
    ->   auth_id     INT NOT NULL PRIMARY KEY,
    ->   auth_name  VARCHAR(20),
    ->  auth_gender CHAR(1)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql> desc authors;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| auth_id     | int(11)     | NO   | PRI | NULL    |       |
| auth_name   | varchar(20) | YES  |     | NULL    |       |
| auth_gender | char(1)     | YES  |     | NULL    |       |
+-------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> INSERT INTO authors  
    -> VALUES (1001, 'WriterX' ,'f'),
    -> (1002, 'WriterA' ,'f'),
    -> (1003, 'WriterB' ,'m'),
    -> (1004, 'WriterC' ,'f'),
    -> (1011, 'WriterD' ,'f'),
    -> (1012, 'WriterE' ,'m'),
    -> (1013, 'WriterF' ,'m'),
    -> (1014, 'WriterG' ,'f'),
    -> (1015, 'WriterH' ,'f');
Query OK, 9 rows affected (0.00 sec)
Records: 9  Duplicates: 0  Warnings: 0

mysql> select * from authors;
+---------+-----------+-------------+
| auth_id | auth_name | auth_gender |
+---------+-----------+-------------+
|    1001 | WriterX   | f           |
|    1002 | WriterA   | f           |
|    1003 | WriterB   | m           |
|    1004 | WriterC   | f           |
|    1011 | WriterD   | f           |
|    1012 | WriterE   | m           |
|    1013 | WriterF   | m           |
|    1014 | WriterG   | f           |
|    1015 | WriterH   | f           |
+---------+-----------+-------------+
9 rows in set (0.00 sec)

mysql> CREATE TABLE authorbook
    -> (
    ->   auth_id  INT NOT NULL,
    ->   bk_id   INT NOT NULL,
    ->   PRIMARY KEY (auth_id, bk_id),
    ->   FOREIGN KEY (auth_id) REFERENCES authors (auth_id),
    ->   FOREIGN KEY (bk_id) REFERENCES books (bk_id)
    -> );
Query OK, 0 rows affected (0.01 sec)

mysql> desc authorbook;
+---------+---------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| auth_id | int(11) | NO   | PRI | NULL    |       |
| bk_id   | int(11) | NO   | PRI | NULL    |       |
+---------+---------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> INSERT INTO authorbook
    -> VALUES (1001, 11033), (1002, 11035), (1003, 11072), (1004, 11028),
    -> (1011, 11078), (1012, 11026), (1012, 11041), (1014, 11069);
Query OK, 8 rows affected (0.00 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> select * from authorbook;
+---------+-------+
| auth_id | bk_id |
+---------+-------+
|    1012 | 11026 |
|    1004 | 11028 |
|    1001 | 11033 |
|    1002 | 11035 |
|    1012 | 11041 |
|    1014 | 11069 |
|    1003 | 11072 |
|    1011 | 11078 |
+---------+-------+
8 rows in set (0.00 sec)

// 1、使用mysqldump命令备份数据库中的所有表
[root@localhostjx ~]# mkdir /backup
[root@localhostjx ~]# mkdir /backup/db
[root@localhostjx ~]# mysqldump -u root -p booksDB > /backup/db/booksdb1.sqlEnter password: 
[root@localhostjx ~]# ll /backup/db/booksdb1.sql
-rw-r--r--. 1 root root 3912 7月  20 20:10 /backup/db/booksdb1.sql

// 2、备份booksDB数据库中的books表
[root@localhostjx ~]# mysqldump -u root -p booksDB >/backup/db/booksdb_book.sql
Enter password: 
[root@localhostjx ~]# ll /backup/db/booksdb_book.sql
-rw-r--r--. 1 root root 3912 7月  20 20:12 /backup/db/booksdb_book.sql

// 3、使用mysqldump备份booksDB和test数据库
[root@localhostjx ~]# mysqldump -u root -p --all-databases > /backup/db/all.sql
Enter password: 
[root@localhostjx ~]# ll /backup/db/all.sql
-rw-r--r--. 1 root root 781282 7月  20 20:15 /backup/db/all.sql

// 	4、使用mysqldump备份服务器中的所有数据库
[root@localhostjx ~]# mysqldump -u root -p --all-databases > /backup/db/all.sql
Enter password: 
[root@localhostjx ~]# ll /backup/db/all.sql
-rw-r--r--. 1 root root 781282 7月  20 20:16 /backup/db/all.sql

// 	5、使用mysql命令还原第二题导出的book表
// 	要先在MySQL数据库中删除表所含有的外键 然后删除表才能进行还原
mysql> use booksDB;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show create table authorbook \G;
*************************** 1. row ***************************
       Table: authorbook
Create Table: CREATE TABLE `authorbook` (
  `auth_id` int(11) NOT NULL,
  `bk_id` int(11) NOT NULL,
  PRIMARY KEY (`auth_id`,`bk_id`),
  KEY `bk_id` (`bk_id`),
  CONSTRAINT `authorbook_ibfk_1` FOREIGN KEY (`auth_id`) REFERENCES `authors` (`auth_id`),
  CONSTRAINT `authorbook_ibfk_2` FOREIGN KEY (`bk_id`) REFERENCES `books` (`bk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR: 
No query specified
mysql> alter table authorbook drop foreign key authorbook_ibfk_2;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> drop table books;
Query OK, 0 rows affected (0.00 sec)

mysql> show tables;
+-------------------+
| Tables_in_booksDB |
+-------------------+
| authorbook        |
| authors           |
+-------------------+
2 rows in set (0.00 sec)
mysql> exit
Bye
[root@localhostjx ~]# mysql  -uroot -p -D booksDB < /backup/db/booksdb_book.sql
Enter password: 
[root@localhostjx ~]# ll /backup/db/booksdb_book.sql
-rw-r--r--. 1 root root 3912 7月  20 20:12 /backup/db/booksdb_book.sql

// 	6、进入数据库使用source命令还原第二题导出的book表
mysql> use booksDB;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-------------------+
| Tables_in_booksDB |
+-------------------+
| authorbook        |
| authors           |
| books             |
+-------------------+
3 rows in set (0.00 sec)

二、索引

1、建立一个utf8编码的数据库test1
	2、建立商品表goods和栏目表category
	按如下表结构创建表：存储引擎engine myisam 字符集charset utf8

		mysql> desc goods;
		+------------+-------------+------+-----+---------+----------------+
		| Field      | Type        | Null | Key | Default | Extra          |
		+------------+-------------+------+-----+---------+----------------+
		| goods_id   | int(11)     | NO   | PRI | NULL    | auto_increment |
		| goods_name | varchar(20) | NO   |     |         |                |
		| cat_id     | int(11)     | NO   |     | 0       |                |
		| brand_id   | int(11)     | NO   |     | 0       |                |
		| goods_sn   | char(12)    | NO   |     |         |                |
		| shop_price | float(6,2)  | NO   |     | 0.00    |                |
		| goods_desc | text        | YES  |     | NULL    |                |
		+------------+-------------+------+-----+---------+----------------+
		7 rows in set (0.00 sec)

		
		mysql> desc category;
		+-----------+-------------+------+-----+---------+----------------+
		| Field     | Type        | Null | Key | Default | Extra          |
		+-----------+-------------+------+-----+---------+----------------+
		| cat_id    | int(11)     | NO   | PRI | NULL    | auto_increment |
		| cate_name | varchar(20) | NO   |     |         |                |
		| parent_id | int(11)     | NO   |     | 0       |                |
		+-----------+-------------+------+-----+---------+----------------+
		3 rows in set (0.00 sec)

	3、删除 goods 表中的 goods_desc 字段及货号字段,并增加 click_count 字段 
	4、在 goods_name 列上加唯一性索引（用alter table方式） 
	5、在 shop_price 列上加普通索引（用create index方式）
	6、在 click_count 上增加普通索引，然后再删除 （分别使用drop index和alter table删除）

//按要求创建数据表
mysql> create table goods(
    -> goods_id int(11) primary key auto_increment,
    -> goods_name varchar(20) not null,
    -> cat_id int(11) not null,
    -> brand_id int(11) not null,
    -> goods_sn char(12) not null,
    -> shop_price float(6,2) not null,
    -> goods_desc text)
    -> ENGINE = myisam CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Query OK, 0 rows affected (0.00 sec)
mysql> desc goods;
+------------+-------------+------+-----+---------+----------------+
| Field      | Type        | Null | Key | Default | Extra          |
+------------+-------------+------+-----+---------+----------------+
| goods_id   | int(11)     | NO   | PRI | NULL    | auto_increment |
| goods_name | varchar(20) | NO   |     | NULL    |                |
| cat_id     | int(11)     | NO   |     | NULL    |                |
| brand_id   | int(11)     | NO   |     | NULL    |                |
| goods_sn   | char(12)    | NO   |     | NULL    |                |
| shop_price | float(6,2)  | NO   |     | NULL    |                |
| goods_desc | text        | YES  |     | NULL    |                |
+------------+-------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)
mysql> create table category(
    -> cat_id int(11) primary key auto_increment,
    -> cate_name varchar(20) not null,
    -> parent_id int(11) not null)
    -> ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Query OK, 0 rows affected (0.01 sec)
mysql> desc category;
+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| cat_id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| cate_name | varchar(20) | NO   |     | NULL    |                |
| parent_id | int(11)     | NO   |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

// 	3、删除 goods 表中的 goods_desc 字段及货号字段,并增加 click_count 字段 
mysql> alter table goods drop goods_desc;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0
mysql> alter table goods drop goods_sn;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> desc goods;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| goods_id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| goods_name  | varchar(20) | NO   |     | NULL    |                |
| cat_id      | int(11)     | NO   |     | NULL    |                |
| brand_id    | int(11)     | NO   |     | NULL    |                |
| shop_price  | float(6,2)  | NO   |     | NULL    |                |
| click_count | int(11)     | YES  |     | NULL    |                |
+-------------+-------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)

// 4、在 goods_name 列上加唯一性索引（用alter table方式）
mysql> alter table goods add unique index(goods_name);
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table goods \G;
*************************** 1. row ***************************
       Table: goods
Create Table: CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(20) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `shop_price` float(6,2) NOT NULL,
  `click_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  UNIQUE KEY `goods_name` (`goods_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
1 row in set (0.00 sec)

//5、在 shop_price 列上加普通索引（用create index方式）
mysql> create index shop_price on goods(shop_price);
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table goods \G;
*************************** 1. row ***************************
       Table: goods
Create Table: CREATE TABLE `goods` (
  `goods_id` int(11) NOT NULL AUTO_INCREMENT,
  `goods_name` varchar(20) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `shop_price` float(6,2) NOT NULL,
  `click_count` int(11) DEFAULT NULL,
  PRIMARY KEY (`goods_id`),
  UNIQUE KEY `goods_name` (`goods_name`),
  KEY `shop_price` (`shop_price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC
1 row in set (0.00 sec)

// 6、在 click_count 上增加普通索引，然后再删除 （分别使用drop index和alter table删除
mysql> create index count on goods(click_count);
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> drop index count on goods;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table goods add index c_count(click_count);
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table goods drop index c_count;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Duplicates: 0  Warnings: 0

三、视图

学生表：Student (Sno, Sname, Ssex , Sage, Sdept)
	学号，姓名，性别，年龄，所在系 Sno为主键
	课程表：Course (Cno, Cname,)
	课程号，课程名 Cno为主键
	学生选课表：SC (Sno, Cno, Score)
	学号，课程号，成绩 Sno,Cno为主键
	
	1、创建一视图 stu_info,查询全体学生的姓名，性别，课程名，成绩。
	2、删除视图 stu_info。

// A code block
mysql> create table student(
    -> Sno int(11) primary key auto_increment,
    -> Sname varchar(50) not null,
    -> Ssex varchar(20) not null,
    -> Sage int(11) not null,
    -> Sdept varchar(50) not null)
    -> ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Query OK, 0 rows affected (0.00 sec)

mysql> desc student;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| Sno   | int(11)     | NO   | PRI | NULL    | auto_increment |
| Sname | varchar(50) | NO   |     | NULL    |                |
| Ssex  | varchar(20) | NO   |     | NULL    |                |
| Sage  | int(11)     | NO   |     | NULL    |                |
| Sdept | varchar(50) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
mysql> create table course(
    -> Cno int(11) primary key auto_increment,
    -> Cname varchar(50) not null)
    -> ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
Query OK, 0 rows affected (0.00 sec)

mysql> desc course;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| Cno   | int(11)     | NO   | PRI | NULL    | auto_increment |
| Cname | varchar(50) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
mysql> create table sc(
    -> Sno int(11),
    -> Cno int(11),
    -> Score int(11),
    -> primary key(Sno,Cno));
Query OK, 0 rows affected (0.01 sec)

mysql> desc sc;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| Sno   | int(11) | NO   | PRI | NULL    |       |
| Cno   | int(11) | NO   | PRI | NULL    |       |
| Score | int(11) | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> insert into student values('801','张老大','男',20,'计算机系');
Query OK, 1 row affected (0.00 sec)

mysql> insert into student values('802','张老二','男',21,'中文系');
Query OK, 1 row affected (0.00 sec)

mysql> insert into student values('803','张三','女',25,'中文系');
Query OK, 1 row affected (0.00 sec)
mysql> insert into student values('804','李四','男',30,'英语系');           
Query OK, 1 row affected (0.00 sec)

mysql> select * from student;
+-----+-----------+------+------+--------------+
| Sno | Sname     | Ssex | Sage | Sdept        |
+-----+-----------+------+------+--------------+
| 801 | 张老大    | 男   |   20 | 计算机系     |
| 802 | 张老二    | 男   |   21 | 中文系       |
| 803 | 张三      | 女   |   25 | 中文系       |
| 804 | 李四      | 男   |   30 | 英语系       |
+-----+-----------+------+------+--------------+
4 rows in set (0.00 sec)
mysql> insert into course values
    -> (001,'英语'),
    -> (002,'数学'),
    -> (003,'语文');
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from course;
+-----+--------+
| Cno | Cname  |
+-----+--------+
|   1 | 英语   |
|   2 | 数学   |
|   3 | 语文   |
+-----+--------+
3 rows in set (0.00 sec)
mysql> insert into sc values
    -> (801,001,85),
    -> (802,003,99),
    -> (803,002,74),
    -> (804,001,89);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from sc;
+-----+-----+-------+
| Sno | Cno | Score |
+-----+-----+-------+
| 801 |   1 |    85 |
| 802 |   3 |    99 |
| 803 |   2 |    74 |
| 804 |   1 |    89 |
+-----+-----+-------+
4 rows in set (0.00 sec)

//1、创建一视图 stu_info,查询全体学生的姓名，性别，课程名，成绩。
mysql> create view stu_info(name,sex,course,score) as
    -> select s.Sname,s.Ssex,c.Cname,sc.Score
    -> from sc,student s,course c
    -> where sc.Sno=s.Sno and sc.Cno=c.Cno;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from stu_info;
+-----------+-----+--------+-------+
| name      | sex | course | score |
+-----------+-----+--------+-------+
| 张老大    | 男  | 英语   |    85 |
| 张老二    | 男  | 语文   |    99 |
| 张三      | 女  | 数学   |    74 |
| 李四      | 男  | 英语   |    89 |
+-----------+-----+--------+-------+
4 rows in set (0.00 sec)

// 2、删除视图 stu_info。
mysql> drop view stu_info;
Query OK, 0 rows affected (0.00 sec)

重庆城科李立川

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫