Finding MySQL is 32bit version or 64 bit version

Finding whether MySQL is 32 bit version or 64 bit is possible with a simple query.

It is , show variables like 'version_compile_machine';

See the output from 32 bit version of MySQL.

mysql> show variables like 'version_compile_machine';
+-------------------------+-------+
| Variable_name           | Value |
+-------------------------+-------+
| version_compile_machine | ia32  |
+-------------------------+-------+
1 row in set (0.00 sec)


For 64bit, I believe the value will be 'x86_64'.

SQL Joins - Understand with Venn Diagram

SQL joins simply explained with Venn diagram. Found it very useful, so thought of sharing with you guys.