2020-08-13 12:00:20 +02:00
|
|
|
---
|
|
|
|
id: 5e7b9f170b6c005b0e76f08b
|
2021-06-23 21:35:24 +05:30
|
|
|
title: 建立关系数据库
|
2020-08-13 12:00:20 +02:00
|
|
|
challengeType: 11
|
|
|
|
videoId: MQ5z4bdF92U
|
2021-10-03 12:24:27 -07:00
|
|
|
bilibiliIds:
|
|
|
|
aid: 249380678
|
|
|
|
bvid: BV1vv411E76L
|
|
|
|
cid: 377531786
|
2021-01-13 03:31:00 +01:00
|
|
|
dashedName: make-a-relational-database
|
2020-08-13 12:00:20 +02:00
|
|
|
---
|
|
|
|
|
2020-12-16 00:37:30 -07:00
|
|
|
# --question--
|
|
|
|
|
|
|
|
## --text--
|
|
|
|
|
2021-06-23 21:35:24 +05:30
|
|
|
您将使用什么 SQL 命令来检索具有电子邮件地址 `quincy@freecodecamp.org` 的所有用户?
|
2020-12-16 00:37:30 -07:00
|
|
|
|
|
|
|
## --answers--
|
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
```sql
|
2020-12-16 00:37:30 -07:00
|
|
|
SELECT Users WHERE email="quincy@freecodecamp.org"
|
|
|
|
```
|
|
|
|
|
|
|
|
---
|
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
```sql
|
2020-12-16 00:37:30 -07:00
|
|
|
SELECT Users WHERE email IS "quincy@freecodecamp.org"
|
|
|
|
```
|
|
|
|
|
|
|
|
---
|
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
```sql
|
2020-12-16 00:37:30 -07:00
|
|
|
SELECT ALL Users WHERE email="quincy@freecodecamp.org"
|
|
|
|
```
|
|
|
|
|
|
|
|
---
|
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
```sql
|
2020-12-16 00:37:30 -07:00
|
|
|
SELECT * FROM Users WHERE email IS "quincy@freecodecamp.org"
|
|
|
|
```
|
|
|
|
|
|
|
|
---
|
|
|
|
|
2021-02-06 04:42:36 +00:00
|
|
|
```sql
|
2020-12-16 00:37:30 -07:00
|
|
|
SELECT * FROM Users WHERE email="quincy@freecodecamp.org"
|
|
|
|
```
|
|
|
|
|
|
|
|
## --video-solution--
|
|
|
|
|
|
|
|
5
|
|
|
|
|