MYSQL DATABASE INTERVIEW QUESTIONS

What are data types in MySQL and why are they important?

Can you name some common numeric data types in MySQL?

What is the difference between CHAR and VARCHAR data types in MySQL?

How do you define a column to store date and time in MySQL?

What is the ENUM data type and how is it used in MySQL?

Explain the difference between TEXT and BLOB data types.

How can you define a column that automatically updates its value to the current timestamp whenever the row is updated?

What is the JSON data type in MySQL and how can it be used?

How do you use the SET data type in MySQL and what are its benefits?

Discuss the advantages and disadvantages of using the DECIMAL data type over FLOAT or DOUBLE in MySQL.