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.