Learning PHP 7 (Video 17)

This video tutorial introduces MySQL, a popular open-source database, and covers basic SQL syntax and operations. It explains how to define a table schema, use Docker to set up MySQL, and perform basic SQL operations like insert, select, update, and delete. The tutorial concludes with a brief introduction to more complex PHP database operations using PDO.

What is the primary purpose of a primary key in a database table?

• To define the data type of a column

• To allow multiple users to access the database simultaneously

• To store user passwords securely

• To ensure each record is unique and speed up queries

Which data type would be most suitable for storing a user's email address in a MySQL table?

• ENUM

• BLOB

• VARCHAR

• INT

What command is used to start a MySQL container using Docker?

• docker init mysql

• docker compose up mysql

• docker start mysql

• docker run mysql

How can you fetch all fields from a table in MySQL?

• SELECT * FROM table_name

• FETCH ALL FROM table_name

• SHOW ALL FROM table_name

• GET ALL FROM table_name

Which SQL statement is used to remove a table and all its data?

• DELETE TABLE table_name

• DROP TABLE table_name

• REMOVE TABLE table_name

• CLEAR TABLE table_name