Simple Example to Create View in MySQL

MySql View is very important factor of Database based on performance. View is virtual table that’s contains result set of your SQL statement. In SQL statement yo can use SQL functions, WHERE, and JOIN statements to get result set. The View table can contain rows and column like your original table the column name may […]

Continue reading


How To Create Index in MySQL Example

Today in web application performance is main issue, So performance can be improved through programming side or database side. In this tutorial I will describe how to improve performance of your application database side.Database Indexes is very important factor to improve performance. When the application has too much data and updated frequently data, which is […]

Continue reading


MySql DATEDIFF() Working Example and Uses

In This tutorial i will describe how to use DateDiff() function of MySql.Date difference is very important function of MySql.Normally we will use server side script to operation of data,but based on performance its very costly,To avoid Server side script MySql provide Date difference function to get refined result from database. Syntex: DATEDIFF(date1,date2) Where date1 […]

Continue reading


Referential Actions In Mysql

Referential integrity is playing very important role when you creating in huge database. When an UPDATE or DELETE operation affects of parent table that has matching rows in the child table. The result also affect child table depends on the referential action specified using ON UPDATE and ON DELETE subclauses of theFOREIGN KEY clause on […]

Continue reading