The CREATE TABLE statement is used to create a table in MySQL. We will create a table named “MyGuests”, with five columns: “id”, “firstname”, “lastname”, “email” and “reg_date”: