Introduction on Mysql Triggers

Introduction on Mysql Triggers

Introduction on Triggers A trigger is a set of actions that are run automatically when a specified change operation (SQL INSERT, UPDATE, or DELETE statement) is performed on a specified table. Triggers are useful for tasks such as enforcing business…

Continue Reading
What are hooks in CodeIgniter?

What are hooks in CodeIgniter?

In CodeIgniter, snares are occasions which can be called when the execution of a program. It permits executing a content with particular way in the CodeIgniter execution process without changing the center records. For instance, it can be utilized where…

Continue Reading
What is routing in CodeIgniter?

What is routing in CodeIgniter?

URL Routing In Php CodeIgniter URLs in CodeIgniter are intended to be short and web index agreeable. It should sound good to the guests. A client ought to get a thought regarding the page content through its URL. For example,…

Continue Reading
How to Upload File in PHP

The most effective method to Upload File in PHP

Record transfer is a most utilized component in the web application. PHP gives a simple method to transfer record to the server. With PHP, you can upload record or pictures to the server by composing negligible code. In this instructional exercise, we’ll…

Continue Reading
How To Setup Maintenance Mode in CodeIgniter

How To Setup Maintenance Mode in CodeIgniter

Maintenance mode helps to improve user experience by showing a notification when the site is going through maintenance. When the web application needs an update, it’s always a good idea to display a well-designed maintenance page instead of showing error…

Continue Reading
What Is MySQL Full-Text Search?What Is MySQL Full-Text Search?

What Is MySQL Full-Text Search?

A:-Introduction to MySQL Full-Text Search Summary: in this tutorial, we will introduce you to MySQL full-text search and its features. MySQL supports text searching by using the LIKE operator and regular expression. However, when the text column is large and…

Continue Reading
MySQL triggers are stored programs that are executed automatically to respond to specific events associated with table e.g., insert, update or delete a record

What is Mysqli Trigger?

Introduction on Triggers A trigger is a set of actions that are run automatically when a specified change operation (SQL INSERT, UPDATE, or DELETE statement) is performed on a specified table. Triggers are useful for tasks such as enforcing business…

Continue Reading
What Is Load Balancing?

What Is Load Balancing?

Load balancing refers to efficiently distributing incoming network traffic across a group of backend servers, also known as a server farm or server pool. Modern high-traffic websites must serve hundreds of thousands, if not millions, of concurrent requests from users or clients and return…

Continue Reading
PL/SQL interview questions and answers

PL/SQL interview questions and answers

1. What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2. What is the basic structure of PL/SQL? PL/SQL uses block structure as its basic structure.…

Continue Reading