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
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.
How to connect to MySQL on Amazon EC2 from Linux / Mac?
Here’s how you can connect to MySQL on Amazon EC2 from Linux / Mac without opening any port by forwarding your local port over SSH
How to connect to MySQL on Amazon EC2 from Windows?
How to backup and restore MySQL database?
When working with MySQL, you may need to backup and restore MySQL database regularly to recover in case of accidents. Here’s how you can do it.
Enable remote access to MySQL database
Usually remote access to MySQL database is disabled for security reasons. However, if you need to provide remote access to MySQL, just follow these steps.