What is the purpose of the INSERT statement in MySQL?
How do you insert data into a specific column of a table in MySQL?
Can you insert multiple rows with one INSERT statement? If yes, how?
What will happen if you try to insert a value into a table where the column has a UNIQUE constraint and that value already exists?
How can you handle errors in MySQL when an INSERT fails due to constraints like NOT NULL violations?
Describe the difference between INSERT INTO and REPLACE INTO.
What is the role of the ON DUPLICATE KEY UPDATE clause in an INSERT statement?
Can you use INSERT to add data into a table from another table? Explain how.
Explain how you would use INSERT with a transaction. What are the benefits?
In the context of group replication and multi-master setups, how does MySQL handle concurrent INSERT operations across different nodes?