Here are a few commonly used commands to find current year, current month and current day in MySQL. You can use date format is different variations for it.
mysql
Difference between SELECT INTO and INSERT INTO in MySQL
What is the difference between using SELECT INTO and INSERT INTO? Both can be used to copy data from one table into another
Copy data into new table in MySQL
You can easily copy data into new table in MySQL using SELECT INTO. This helps you create temporary tables quickly.
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 do a bulk insert in MySQL?
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.
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.
How to find difference between two dates in MySQL
Calculating difference between two dates in MySQL is really easy. Here’s how you can do it. Let’s say dt1 and dt2 are 2 columns in table table_name.
MySQL Tutorial : MySQL IN clause (Basic)
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.
MySQL Tutorial : MySQL IN statement (Advanced)
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.
How to find MySQL database location on your hard disk?
MySQL database location on your hard disk in the following ways: MySQL database location in Windows 1) Locate the my.ini file, which store in the MySQL