In my previous post, I talked about the SELECT statement being the key to writing INSERT, UPDATE, and DELETE statements. Now let’s build on that.
I am putting together an Intro to SQL presentation for a local meetup. The goal is to go over the basics of the CRUD operation SQL statements (Create\ Insert, Read\Select, Update, Delete), especially for those who are new to SQL.
As I am putting this presentation together, I seem to have acquired a deeper appreciation of the SELECT statement. With the proper SELECT statements, I realized that you can accomplish 75% of what you need to do working with databases. OK, I’m totally making up that percentage but you can do a whole lot with a good SELECT statement.
I think there’s a lot to look at with this so I’ll talk about those in future posts. But for now, let’s start with this idea:
If you can write a SELECT statement, you can write an INSERT, UPDATE or DELETE statement.