MySQL Database

1.1 Understanding on General Database concepts

A database is an application that organized a collection of data to store in particular way.
Learn More...

1.2 Feature of MySQL Database

MySQL is a free, open-source database engine available for different platforms. MySQL represents an introduction to modern database technology for high-volume application.
Learn More...

1.3 Install the MySQL Server on windows

To install MySQL database, follow the given below options and setup MYSQL -
Learn More...

1.4 Starting MySQL Database

Before start the MySQL Server, you should set the path for MySQL Server. To set the path of MySQL Server, you need to follow some steps given below -
Learn More...

1.5 Retrieving Information from a Table

This content provides introduction of various queries to retrieving Information from table by using where and like clause .
Learn More...

1.6 Retrieving Information from two or more Table by using MySQL Join

Normally we are retrieve information from one table ay a time. This is correct for simple application, but in real time application MySQL uses queries to get data from multiple tables in a single query.
Learn More...

1.7 MySQL Functions and Grouping query data with aggregate functions

In MySQL you can create own function to return specific data. Function are normally used for computation.
The retutn clause is mandatory for a function. It indicates the return type of the function, and the function body must contain a RETURN value statement.
Learn More...

1.8 MySQL Stored Procedure

A stored procedure is a procedure that is used to store data into database and retrieve data from multiple tables.
Stored procedure has a name, a parameter list, and an SQL statement, which can contain many more SQL statements.
Learn More...

1.9 Import/Export mysql Data

To import and export data from table to text file using command line you can use some queries which will further given ahead -
Learn More...

1.10 MySQL Storage Engines

A storage engine is a software system that stores, handles, and retrieves information from a table. MySQL supports several storage engines that act as handlers for different table types.
Learn More...

1.11 MySQL Queries

A storage engine is a software system that stores, handles, and retrieves information from a table. MySQL supports several storage engines that act as handlers for different table types.
Learn More...