MySQL Basics

MySQL Database Files

November 28th, 2013
In MySQL database installation, a directory has set of files which contain database metadata and data. That is the database schema and conta

MySQL vs MySQLi in PHP

October 30th, 2013
MySQL and MySQLi are PHP database extensions implemented by using PHP extension framework. PHP database extensions are used to write PHP cod


August 30th, 2013
For MySQL, there are several inbuilt functions, that could be used while writing queries. We have seen some of them, like, MySQL datetime fu

MySQL OrderBy

July 16th, 2013
MySQL orderby clause is used to order results based on a column. Orderby clause is used in select queries to do sort by specifying the colum

MySQL Data Types

July 4th, 2013
When we see about PHP data types, we have listed set of possible types of data with which the PHP variable may be initialized. Similarly, My

MySQL Date Time

June 30th, 2013
In MySQL, it includes set of date and time-related functions for performing manipulation over data which indicate the date, time or both. Us


June 8th, 2013
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

MySQL Left Join

May 25th, 2013
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 16th, 2013
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

MySQL JOINs: An Introduction

April 27th, 2013
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

↑ Back to Top