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…