Saturday, November 19, 2016

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:

Sunday, November 13, 2016

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.

Tuesday, June 21, 2016

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?

Sunday, May 1, 2016

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.

Friday, April 1, 2016

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.

Saturday, March 19, 2016

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.

Sunday, February 28, 2016

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.

Friday, January 1, 2016

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.