The purpose of this chapter is to explain the statements of the Structured Query Language (SQL), the programming language for database interactions.
SQL is the standard way for programs to access databases. This includes creating tables, adding records, modifying or deleting records, and reading records. Although there are differences in the implementation of SQL by the different products, those differences are relatively minor. An example is that Access refers to character strings as TEXT, and MySQL uses the term CHAR.
HTML is interpreted by the browser on the client computer.
The SQL statements are interpreted by the DBMS drivers, namely MS Access or MySQL. The DBMS is either on the server or a computer connected to the server.
We cover the details of the connections to the database products and the intricacies of preparing the SQL statements in later chapters. This chapter will focus on what you can call “stand-alone” SQL statements—a worthy enough subject in its own right.