MySQL Basics

Recent Tutorial

MySQL Database Files

November 28, 2013
In MySQL database installation, a directory has set of files which contain database metadata and data. That is the database schema and containing values. These files are, .frm – contains schema .myd – contains data .myi – contain indices All the above list of files may not be available in MySQL database directory. It depends […]
This tutorial was added to MySQL.

MySQL vs MySQLi in PHP

October 30, 2013
MySQL and MySQLi are PHP database extensions implemented by using PHP extension framework. PHP database extensions are used to write PHP code for accessing the database. They expose database API to provide interfaces to use database functions. MySQL extension is deprecated and will not be available in future PHP versions. It is recommended to use […]
This tutorial was added to PHP.

MySQL CONCAT

August 30, 2013
For MySQL, there are several in-built functions, that could be used while writing queries. We have seen some of them, like, MySQL datetime functions, CURDATE(), CURTIME() and etc. Such direct functions will be helpful for performing manipulation with MySQL table data. We can perform string concatenation by using direct function provided by MySQL. In MySQL, […]
This tutorial was added to MySQL.

MySQL OrderBy

July 16, 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 column order (asc, desc). If no order is given, then asc is the default order. Syntax, SELECT * FROM table_name ORDER BY column_name desc Using Orderby clause we can get […]
This tutorial was added to MySQL.

MySQL Data Types

July 4, 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, MySQL supports huge list of data types, and it is mandatory to specify the data type of each attribute of a table, unlike PHP, a loosely typed language that we […]
This tutorial was added to MySQL.

MySQL Date Time

June 30, 2013
In MySQL, it includes set of date and time related functions for performing manipulation over data which indicate date, time or both. Using these functions, some common operations taken place are listed below. Getting current Date/Time/Timestamp. MySQL Date/Time formatting. Date/Time/Timestamp arithmetic operations. Converting MySQL Date/Time/Timezone. Extracting date from MySQL Temporal Data. For performing the above […]
This tutorial was added to MySQL.

MySQL Right JOIN

June 8, 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 before. But, right JOIN differs with the starting point with which table data is preserved to compare other table. It preserves right table data, instead of considering […]
This tutorial was added to MySQL.

MySQL Left Join

May 25, 2013
When we have seen an introduction on MySQL JOINs, we have also see about the list of available types in it. Among them, we have started with Left Join to know how it is used to retrieve rows from more than one table by providing possible join condition. Unlike simple join, here, the ON clause […]
This tutorial was added to MySQL.

MySQL SHOW

May 16, 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 tables and also table column, index and etc. But some of the SHOW command will return limited information based on the access privileges. In this article, we are going to […]
This tutorial was added to MySQL.

MySQL JOINs: An Introduction

April 27, 2013
This article is started with MySQL simple JOIN concept with PHP script. JOINs in database queries are used to retrieve data from more than one table using single query. On executing the join query, this will return a table in virtual manner which is not present  in database actually. For example, let there are two […]
This tutorial was added to PHP.

↑ Back to Top