Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
You can easily copy data into new table in MySQL using SELECT INTO. This helps you create temporary tables quickly.
You may need to copy data from one table into another. You can insert data from one table into another in MySQL.You can use the INSERT INTO SELECT statement
Sometimes you may need to select data from a table and insert into same table in MySQL. You may need to quickly create lot of data for testing.
A bulk insert in MySQL is when you need to insert a lot of records in a table. You may need to do it to quickly create data for testing.
MySQL IN clause can be used instead of using OR operator with Where clause. It can be used when where clause is applied for multiple values for same column in an SQL query.
The basic use of MySQL IN statement deals with one column being compared to multiple values. There are also couple of advanced uses which make interesting use cases.