47.如何获取emp_v和employees有相同的数据no.md · 天行者/数据库SQL实战

Create your Gitee Account

Explore and code with more than 12 million developers，Free private repositories ！：）

文件

This repository doesn't specify license. Please pay attention to the specific project description and its upstream code dependency when using it.

Clone or Download

47.如何获取emp_v和employees有相同的数据no.md 914 Bytes

Copy Edit Raw Blame History

authored 2020-09-29 10:30 . 如何获取emp_v和employees有相同的数据no

<!--
 * @Author: your name
 * @Date: 2020-09-21 17:24:24
 * @LastEditTime: 2020-09-29 10:30:08
 * @LastEditors: your name
 * @Description: In User Settings Edit
 * @FilePath: \database-sql-combat\47.如何获取emp_v和employees有相同的数据no.md
-->
# 如何获取emp_v和employees有相同的数据no

## 题目描述

存在如下的视图

``` mysql
create view emp_v as select * from employees where emp_no >10005;
```

如何获取emp_v和employees有相同的数据？

``` mysql
CREATE TABLE `employees` (
`emp_no` int(11) NOT NULL,
`birth_date` date NOT NULL,
`first_name` varchar(14) NOT NULL,
`last_name` varchar(16) NOT NULL,
`gender` char(1) NOT NULL,
`hire_date` date NOT NULL,
PRIMARY KEY ( `emp_no` ));
```

## 答案

``` mysql
select e.* from employees e,emp_v ev where e.emp_no = ev.emp_no
```

## 题解

视图的数据源于employees，只需要确保employees.emp_no=emp_v.emp_no即可

马建仓 AI 助手

尝试更多

代码解读

代码找茬

代码优化

SQL

https://gitee.com/icanflyusa/database-sql-combat.git

git@gitee.com:icanflyusa/database-sql-combat.git

icanflyusa

database-sql-combat

数据库SQL实战

master

天行者/数据库SQL实战

About

Releases

Contributors

Activities