Sometimes you may need to compare databases in MySQL. Here’s how to compare databases in MySQL using command line interface.
MySQL Compare Databases
How to Search a File in Linux
Many times you may need to search a file in Linux / Unix. Here’s how to find a file in Ubuntu and other Linux systems.
How To Create User in MySQL
Many times you may need to create new user for a database in MySQL. Here’s how to create user in MySQL.
Calculate percentile from recency in MySQL
Calculate percentile from recency in MySQL. E.g, to rank customers based on recency of purchases or orders
How to insert into same table in MySQL?
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.
How to calculate age from date of birth in SQL
Here’s how to calculate age from date of birth in SQL you can use the following MySQL query. This is useful to find out recency of activity.