- What is MySQL, and how does it differ from other database management systems?
- Explain the difference between a SQL statement and a SQL script in MySQL.
- What are the key features of MySQL?
- How do you create a new database in MySQL?
- What is a table in MySQL, and how can you create one?
- What are the different data types supported by MySQL?
- Explain the primary key, foreign key, and unique key constraints in MySQL.
- How do you insert data into a MySQL table?
- What is the difference between the
DELETE
and TRUNCATE
statements in MySQL?
- How do you retrieve data from a MySQL table using the
SELECT
statement?
- What is an index in MySQL, and why is it important?
- Explain the purpose of the
WHERE
clause in a SQL query.
- What is SQL injection, and how can you prevent it in MySQL?
- What is a stored procedure in MySQL, and why would you use it?
- How can you update records in a MySQL table using the
UPDATE
statement?
- Explain the concept of normalization in databases.
- What is a join in MySQL, and what are the different types of joins?
- How do you create a backup of a MySQL database?
- What is the difference between
CHAR
and VARCHAR
data types in MySQL?
- What are the advantages of using transactions in MySQL?