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
MySQL JOINs: An Introduction

MySQL JOINs: An Introduction

This article is started with MySQL simple JOIN concept with a PHP script. JOINs in database queries are used to retrieve data from more than one table using a single query. On executing the join query, this will return a…

Continue Reading
PHP Image Upload Using jQuery and MySQL

PHP Image Upload Using jQuery and MySQL

This is another image upload tutorial using php, jQuery and MySQL. I have already shared tutorial Image Upload,Crop and Resize Using PHP, jQuery and Ajax.This tutorial is uploading image to folder and store image name into database table.I am not…

Continue Reading
CodeIgniter CRUD Operations with MySQL

CodeIgniter CRUD Operations with MySQL

CRUD (Create, Read, Update and Delete) operations are commonly used to manipulate data in the database. Almost, all web application used Add, Edit, Update and Delete functionality for managing data. In this tutorial, we will create a simple CRUD application…

Continue Reading
Delete multiple records from MySQL in PHP

Delete multiple records from MySQL in PHP

Delete records one by one is very time consuming. Multiple records delete on a single click is strongly recommended for every data management section. Today we will discuss how to delete multiple rows from MySQL database in PHP with checkbox.…

Continue Reading

Introduction on Triggers

[vc_row][vc_column][vc_column_text] 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…

Continue Reading
What are Indexing in mysql and sql?

What are Indexing in mysql and sql?

[vc_row][vc_column][vc_column_text]A database index is a data structure that improves the speed of operations in a table. Indexes can be created using one or more columns, providing the basis for both rapid random lookups and efficient ordering of access to records.…

Continue Reading