Summary

This chapter has shown the basic operations of any database:

• Table creation (CREATE TABLE)
• Table destruction (DROP TABLE)
• Displaying (SELECT)
• Adding (INSERT)
• Replacing (UPDATE)
• Removing (DELETE)

This chapter has shown these commands in their simplest forms; real-world queries are much more complex. The next chapters will show how these simple commands can be used to handle some very complicated tasks.