MYSQL DATABASE INTERVIEW QUESTIONS

What are rows and columns in a MySQL table?

How do you insert a new row into a MySQL table?

How do you select all rows from a MySQL table?

How can you update data in a specific row of a MySQL table?

What is the purpose of the WHERE clause in MySQL?

How do you delete specific rows from a MySQL table?

How do you retrieve distinct values from a column in MySQL?

What is the JOIN clause and how does it work with rows and columns?

How can you use subqueries to work with rows and columns in MySQL?

Explain how to use the GROUP BY clause with aggregate functions to summarize data by rows and columns.