How to INNER JOIN on the same table twice in SQL statement

Having more than one INNER JOIN to the same table can be confusing. More than one INNER JOIN can create a messy SQL statement. If you don’t use aliases they can become difficult to read. So join them with aliases, as explained below. For example say you have the following two tables: Users and Products. […]

What alternatives database engines are there to MySQL?

Unsure what alternatives there are to MySQL? Looking for increases in MySQL performance? You might not realize that there are some compatible relational database engines. That you can drop in to replace MySQL. You can even run SQLite without needing a server stack. SQLite is the most widely deployed database engine in the world Each […]