ABSTRACT
Most relational database systems (RDBSs) adopt the basic syntax of Structured Query Language (SQL) data definition language (DDL) and data manipulation language (DML) discussed in Chapter 8, but may have some minor variations. In this chapter, a widely used open-source database system, MySQL, is introduced. First, the use of DDL and DML in MySQL is illustrated, followed by the discussions on the use of transaction control language (TCL) and data control language (DCL). Some unique features of MySQL, specifically, the utilities, the tools, and some SQL variations of MySQL, are also introduced. Since MySQL products are enhanced regularly, this chapter only covers the key aspects of this database system. When using a particular system version, it is recommended to consult the user manuals available online (https://www.mysql.com) for specific details.
