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 inbuilt 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 the direct function provided by MySQL. In […]
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 the 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 of which table data is preserved to compare another table. It preserves right table data, instead of considering […]
This tutorial was added to MySQL.

MySQL Left Join

May 25, 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 are going to see an example to read data from more than one tables using Left JOIN. Also, we are going to see the possible use cases of where to use ON […]
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 commands 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
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 the JOIN query with the use of ON or USING clause. The join conditions are written based on the common column name, data or indexes of the tables.  In this tutorial, we are […]
This tutorial was added to PHP.

↑ Back to Top