How To Create MySQL Trigger

| Last Updated: | In: Mysql, Oracle


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 time example here, when a new entry ( New Employee Joining) inserted in to employee …


How to delete duplicate data from database table

| Last Updated: | In: 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 fields. Bellow example show how to create UNIQUE Index in mysql database. If you have created fname and lname is …


Responsive country,state,city dropdown using PHP

| Last Updated: | In: Core php, Freebies, Javascript & Ajax, Mysql


I got many request to Responsive country,state,city dropdown values from the database without refresh page using Ajax and PHP. In this article, I’ve put three drop down of country,state,city, drop downs without refreshing the page. All the country, state, city data and their licensing is free to use so you can use this data for …


How To Install Linux, Apache, MySQL, PHP (LAMP) Server on Ubuntu

| Last Updated: | In: Freebies, Mysql


LAMP stack is a group of open source software used to get web servers up and running. The acronym stands for Linux, Apache, MySQL, and PHP. As a solution stack, LAMP is suitable for building dynamic web sites and web applications. The LAMP model has since been adapted to other componentry, though typically consisting of …


How to write multiple queries using MySQL Transaction

| Last Updated: | In: 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 new transaction. COMMIT commits the current transaction, making its changes permanent. ROLLBACK rolls back the current transaction, canceling its changes. …


Facebook style photo gallery with comments

| Last Updated: | In: Core php, HTML / CSS, Javascript & Ajax, Mysql


Have you thought about own facebook-style photo gallry system with comments? I have and today I prepared it for you. In this post i explained the easy way to create your Facebook style photo gallery with comments application. I used to create the ajax, php, and mysql as database to store the gallery details. . …


Backup your Web Projects Database using MySQL Administrator

| Last Updated: | In: 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 use and using this we can take backup and restore web projects database. Download MySQL Administrator MySQL Workbench provides DBAs …


How to create and use Mysql Trigger

| Last Updated: | In: Mysql, Oracle


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 trigger is called automatically when a data modification event is made against a table whereas …


Follow us!

Get Free Access of 350+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW