Skip to Content
《Head First SQL》 (Chinese Edition), 2nd Edition
book

《Head First SQL》 (Chinese Edition), 2nd Edition

by Kimberly Fessel
June 2026
740 pages
13h 7m
Chinese
O'Reilly Media, Inc.
Content preview from 《Head First SQL》 (Chinese Edition), 2nd Edition

第 5 章. CRUD 操作:掌控您的数据

本作品已使用人工智能进行翻译。欢迎您提供反馈和意见:translation-feedback@oreilly.com

Image

准备好全面掌控您的数据了吗?您即将学习的这些命令将完善您的知识体系,让您展现出自己作为 SQL 高手应有的实力。您已经能够创建任何想要的数据库,甚至可以创建一个附近餐厅的数据库,这样您就不再需要把那 39 份外卖菜单塞在厨房的杂物抽屉里了。 你可以添加关于自己最喜欢的酒吧和小餐馆的信息,还可以查询那些全天候营业的深夜小店。

但如果你的常去之地 营业时间 营业时间会怎样?或者——天哪——如果它彻底关门,而你需要 将其从你的数据库中删除呢?数据不仅需要创建,还需要通过 通过在必要时更新或删除信息 。在本章中,你将学习如何通过所有必要的 CRUD操作来全面掌控你的数据库。CRUD在这里可是件好事,所以让我们开始CRUD起来吧!

今晚吃什么?

你最近搬到了大城市 Dataville,在 DataU 上大学。你精通 SQL 的名声迅速传开,已经和一位名叫 Josh 的同学兼 SQL 爱好者成为了朋友。

原来,你和乔什都是美食爱好者,但大多数晚上,你们出于习惯总是在同一家当地汉堡店碰面。最近,你对他们常点的菜已经感到厌倦,因此需要一种更好的方式来决定去哪里吃饭。

Image
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Overcome a Power Deficit

How to Overcome a Power Deficit

Cyril Bouquet, Jean-Louis Barsoux
Relational Power Is the New Currency of Hybrid Work

Relational Power Is the New Currency of Hybrid Work

Lebene Soga, Yemisi Bolade-Ogunfodun, Nazrul Islam, Joseph Amankwah-Amoah

Publisher Resources

ISBN: 0642572408114