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.