Running CRUD with SQL

As the most important data manipulation technology for relational databases, SQL provides full support for CRUD operations. Here is a breakdown of the different SQL statements involved in the CRUD process.

CREATE

In any system, there are two ways to create datasets. You can create a table structure first and insert data into this table at a later phase, or you can create the table by designating what data will be stored in this table, and the table will inherit the structure of the incoming data. SQL provides statements for both approaches. The SQL CREATE statement allows you to create a table definition and run a separate INSERT statement or COPY command to populate the table, and you can also run the CREATE statement with a SELECT clause, which reads data from other datasets and creates the table directly based on the data. You will go through both approaches in this chapter. Then, you will go through the COPY command in Chapter 3.

READ

SQL uses the SELECT statement...