How to deal with NULL values in MySQL

Null values are different than any other value in the world, you cannot use the qual operator when working with null values, query like this will not work:

How to count how many table inside a database

When first starting a project, you probably just creating a few tables inside a database, but as the project gets more mature, the application is growing and you end up having so many tables. On mysql you can count the number of tables inside a database with a special query.

How to reset MySQL root password from MySQL CLI

Here's how to reset MySQL root password from command line

How to show table structure on MySQL

You can get records from a table using 'SELECT' statement on MySQL, but what about getting the structure of the table itself?

How to empty table records in MySQL

Sometimes when you are testing on an application, you want to empty the data/records inside a table, just to make sure that the data is correctly inserted. In this article i want to show you how to empty the whole data/records on a single table.

How to show MySQL version in query

If you want and you needed, you can get information about mysql version from within your mysql query, in this article i will show you how to do that.

How to do sub query on MySQL

Sub query is method of using select statement within another statement, so basically you can have multiple select inside your regular query.

Sub query probably little bit confusing at first, specially for a beginner like me, but once you know how to do it, it's actually quite easy to do.