How To Create MySQL Trigger

This article will explain how to create Trigger in mysql. A mysql trigger is a procedural code which is automatically executed after response to certain events on a particular table or view in a database. I am taking a real […]

Read More…

How to delete duplicate data from database table

Hi friend, today i am going to share How to delete duplicate data from database table. For preventing from duplicate entries in datatbase table you cna use PRIMARY KEY or UNIQUE Index on table with fields. Bellow example show how […]

Read More…

How to write multiple queries using MySQL Transaction

A transaction is a sequential group of database manipulation operations, which is performed as if it were one single work unit. These statements provide control over use of transactions: START TRANSACTION or BEGIN start a new transaction. COMMIT commits the […]

Read More…

Backup your Web Projects Database using MySQL Administrator

Keeping a back up of your database is one of the most important tasks you should be performing, the utmost care should be taken to ensure you have an up-to-date backup. It’s very easy to use and using this we […]

Read More…

How to create and use Mysql Trigger

Introduction to SQL Trigger A SQL trigger is a special type of stored procedure. It is special because it is not called directly like a stored procedure. The main difference between a trigger and a stored procedure is that a […]

Read More…

Generating HTML Reports from SQL*Plus

This post explains how to generate a HTML reports from your Sql *plus query results. You can produce HTML output in AN interactive SQL*Plus session victimization the SET MARKUP command. you\’ll be able to embrace AN embedded sheet, or the […]

Read More…

create and call procedure in mysql ( Updated 2016 )

In this post i will explain how to create store procedure in mysql and how to call store procedure in PHP for select, insert, update and delete data from mysql table. A stored procedure has a header and a body […]

Read More…

Oracle Tutorial for beginners

In the late 1960s/early 1970s, specialised data management software appeared – the first database management systems (DBMS). These early DBMS were either hierarchical (tree) or network (CODASYL) databases which were complex and inflexible and could not easily  be modified for […]

Read More…