How To Create MySQL Trigger

Prem Tiwari - - Mysql, Oracle


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. …

How to delete duplicate data from database table

Prem Tiwari - - Mysql, Oracle


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 …

How to write multiple queries using MySQL Transaction

Prem Tiwari - - Mysql, Oracle


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 …

Backup your Web Projects Database using MySQL Administrator

Prem Tiwari - - Mysql, Oracle


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 …

How to create and use Mysql Trigger

Prem Tiwari - - Mysql, Oracle


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 …

Generating HTML Reports from SQL*Plus

Prem Tiwari - - Mysql, Oracle


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 …

create and call procedure in mysql ( Updated 2016 )

Prem Tiwari - - Mysql, Oracle


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 …

Oracle Tutorial for beginners

Prem Tiwari - - Oracle


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 …