MYSQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the SELECT INTO statement in MySQL?

How do you use SELECT INTO to create a new table with data from an existing table?

Can SELECT INTO be used to copy only specific columns from one table to another? How?

What happens if the new table already exists when using SELECT INTO?

How can you handle the situation where you need to create a new table with a subset of data from an existing table using SELECT INTO?

Explain how you can rename columns when using SELECT INTO.

Discuss the limitations of using SELECT INTO in MySQL.

How can you ensure data consistency and integrity when using SELECT INTO with large datasets?

Can SELECT INTO be used in conjunction with complex queries involving joins and subqueries? Provide an example.

In a scenario where you need to create a backup of a table using SELECT INTO, what steps would you follow, and what considerations should you keep in mind?