3 Introduction to SQL
To select data from a MySQL database, you’ll use Structured Query Language (SQL). SQL is the standard language for querying and managing data in an RDBMS like MySQL.
SQL commands can be categorized into Data Definition Language (DDL) statements and Data Manipulation Language (DML) statements. So far, you’ve been using DDL commands like create database, create table, and drop table to define your databases and tables.
DML commands, on the other hand, are used to manipulate the data in your existing databases and tables. In this chapter, you’ll use the DML select command to retrieve data from a table. You’ll also learn ...
Get MySQL Crash Course now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
