MySQL Interview Questions & Answers

What are MySQL Storage Engines?

How to select Top 10 records in MySQL?

Write a MySQL query to select students with less than 50% marks

Write a MySQL query to select students with marks between 70 and 80

Write a query to fetch top N records

Write a query to find the names of employees that begin with ‘S’

Write a query to create a new table which consists of data and structure copied from the other table

Write a query to retrieve the first four characters of name from the student table

Write a query to select if column has no/empty value

What is MySQL?

What is the difference between SQL and MySQL?

What is a primary key in MySQL?

What is a foreign key in MySQL?

What is the difference between DELETE, TRUNCATE and DROP?

What is the difference between WHERE and HAVING?

What is the difference between INNER JOIN and LEFT JOIN?

What is the difference between CHAR and VARCHAR in MySQL?

What is an index in MySQL?

What is normalization in MySQL?

What is the difference between UNION and UNION ALL?