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.
Connect to Amazon EC2 Linux instance from Linux/Mac using SSH
Here’s how you can connect to Amazon EC2 Linux instance from your Linux/Mac laptop, using SSH.