A comprehensive discussion on SQL will not be covered here, as it is beyond the scope of this book. However, there are a few common SQL commands to create and manipulate entries in a database table that you can try on our current data. They are as follows:
- SELECT: This command is used to query data from one or multiple tables. By specifying attribute (row) names in this command, you can specify which attributes from the tables to be queried should be returned. You can also use * to indicate that all attributes should be returned.
- INSERT: This command adds new entries (rows) into a given database table. Within an INSERT command, you specify the value of each attribute the new entry should hold; otherwise, the default values ...