What is the difference between using SELECT INTO and INSERT INTO? Both can be used to copy data from one table into another
data
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 solve MySQL character encoding problem?
MySQL character encoding problem is where your MySQL database causes Unicode characters (like å, ä and ö) to be displayed wrongly. You can set it to UTF8.
How to find largest table in MySQL database?
Sometimes you may need to keep track of largest table in MySQL database to optimize it. Here’s an SQL query to find the largest table in MySQL database
How to get MySQL database size for your database?
Here’s how to get MySQL database size for all or a specific database. You can use the following SQL query to get it.
How to get MySQL table size for tables in database?
Get MySQL table size for a table in your database with the following SQL query. MySQL table size is the sum of data length and index length.