By Team Escalera on 14 Oct 2017 11:55 AM
  • Trigger

We are going to discuss about TRIGGERS in SQL – SERVER in this article. Triggers are very important in enterprises level database management. You have to understand following table:
This command will create a table on which we will apply triggers:

1. Create table Staff(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), name varchar(55), email varchar(55));
2. Create table Log_Audit(id int NOT NULL PRIMARY KEY IDENTITY(1, 1), StfId int, StfName varchar(50),&nbs...............

By Team Escalera on 31 Oct 2017 01:00 PM
  • MySQL

A local MySql database is used for locally hosted website and web development as discussed in the previous articles.

Why MySql ?

MySql is opensource.
MySql queries are as simple as writing a sentence to fetch data (after some practice).
MySql support community and user base is huge. You will get answers for almost any query on forums.

How to transfer MySql database ?

  • Go to your database or table after opening localhost/phpmyadmin.
  • ...............