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

↑ Back to Top