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:
Saturday, November 19, 2016
Sunday, November 13, 2016
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.
Thursday, July 14, 2016
Tuesday, June 21, 2016
Sunday, May 1, 2016
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
Saturday, March 19, 2016
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.