rohitabstract MySQL

Types of Joins in SQL

A JOIN is a means for combining fields from two tables by using values common to each. An SQL JOIN clause is used to combine records from two or more tables while querying a database. All subsequent explanations on join types in this article make use of the following two tables. Employee Table LastName DeptID … Continue reading Types of Joins in SQL

Advertisements
rohitabstract MySQL

MySQL Full Text Searching

Full Text Searching is a method of searching data. In MySQL,  Full Text Searching literally allows us to search for a needle in a haystack in no time ! In order to use this feature, a full text index has to exist on a the given column. In MySQL, this type of index is only … Continue reading MySQL Full Text Searching