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 …

Sql User Table Schema For Yii2 Starter Kit

| Last Updated: | In: Mysql, Yii framework


Are you going to develop your web application in yii2 framwork, then this article will help you. The user table schema is not provided with yii2 starter kit by yii2 framework package. Below is proper user table schema. How to create user table schema for yii2 1) Create database fro your yii2 application. 2) Open …

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: Freebies, Javascript & Ajax, Mysql, PHP Tutorial


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 …

Getting Started with MongoDB and PHP

| Last Updated: | In: Mysql, PHP Tutorial


This tutorial provides an introduction to basic database operations using the mongo shell. MongoDB is a document database that provides high performance, high availability, and easy scalability. MongoDB is a free and open-source cross-platform document-oriented database program with NoSQL database. It stores data in json format. MongoDb is developed by MongoDB Inc in 2007. How …

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