MySQL Basics
MySQL Database Files
In MySQL database installation, a directory has a set of files that contain database metadata and data. That is the database schema and cont ...
November 28th, 2013
MySQL vs MySQLi in PHP
MySQL and MySQLi are PHP database extensions implemented by using the PHP extension framework. PHP database extensions are used to write PHP ...
October 30th, 2013
MySQL CONCAT
For MySQL, there are several inbuilt functions, that could be used while writing queries. We have seen some of them, like, MySQL datetime fu ...
August 30th, 2013
MySQL OrderBy
MySQL “ORDER BY” clause is used to order results based on a column. This clause is used in select queries to do sort by specifyi ...
July 16th, 2013
MySQL Data Types
When we see PHP data types, we have listed a set of possible types of data with which the PHP variable may be initialized. Similarly, MySQL ...
July 4th, 2013
MySQL Date Time
In MySQL, it includes set of date and time-related functions for performing manipulation over data that indicate the date, time or both. Usi ...
June 30th, 2013
MySQL Right JOIN
Right, JOIN in MySQL is for the same purpose of getting columns from more than one table as like as MySQL Left JOIN we have seen some days b ...
June 8th, 2013
MySQL Left Join
Left JOIN is one of the methods used in joining the database tables as we have seen in the introduction of MySQL JOINs. In this tutorial, we ...
May 25th, 2013
MySQL SHOW
In Mysql, SHOW command is used to get the details of database users and their privileges. Using this command we can show database and its ta ...
May 16th, 2013
MySQL JOINs: An Introduction
MySQL JOINs are used to read data by connecting two or more related tables. While joining MySQL tables, we need to specify the condition for ...
April 27th, 2013
Hi, I'm Vincy. I help build websites, grow businesses, big and small. If that is what you want, contact me.
I'm currently available for freelance work.