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 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 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.

How to import large data on MySQL

If you have a large data, and you want to import that data to let's say an empty database, you will have a hard time doing it with phpmyadmin or mysql workbench.

MySQL Workbench is our best friend

When working with MySQL database, like for example finding the right query, we need tools that can help us run the query easily, a graphical application would be appreciated.