MYSQL DATABASE INTERVIEW QUESTIONS

What is the DEFAULT constraint in MySQL?

How do you define a DEFAULT value for a column in a MySQL table?

What happens if you try to insert a NULL value into a column with a DEFAULT constraint?

How can you modify an existing column to add a DEFAULT value in MySQL?

How do you remove a DEFAULT value from a column in MySQL?

Can you use expressions as default values in MySQL? Provide an example.

How does the DEFAULT constraint interact with the INSERT statement when inserting multiple rows?

How can you use the DEFAULT constraint in combination with other constraints such as NOT NULL?

How can you use the DEFAULT constraint to simplify data insertion in a MySQL table with many columns?

Explain the advantages and potential pitfalls of using the DEFAULT constraint in MySQL.