In the previous tutorial, we have seen what is Boolean full-text search and how it works. In this tutorial, we will see what is natural language full-text search, how it is different from boolean full-text search, what is its syntax and how to implement it with practical examples. This is going to be a very …
MySQL provides us with multiple methods for searching functionalities. The “LIKE” clause is supposed as the best searching method for easy and less complex use cases. For complex business logic, there are other alternative methods that are very effective, suitable, and easy to implement. In this tutorial, we will learn about the boolean full-text search …
In this tutorial, we will study MySQL First_Value() function. Without further ado, let’s get started. Introduction to MySQL First_Value Function As the name suggests, the MySQL First_Value function allows us to select the first value from a given column. It is useful when we want to retrieve the topmost row from a column or select …
In this tutorial, we will study Collation in MySQL. Let’s get right into the topic without any further ado. Also read: MySQL COALESCE() Function Introduction to MySQL Collation A MySQL collation is basically a set of rules which is used to compare the characters in a character set. A character set is a set of …
In this tutorial, we’ll understand what’s indexing, why indexing is used in SQL, the types of indexing, and when to use indexing. Introduction Indexing is used for faster access to data in a table or tables rather than using the normal way of searching the whole table. To understand the topic better let’s take an …
In this tutorial, we will study how to update the records of the table using the Nodejs application. Update the table from NodeJS program To update the records in the table, the UPDATE statement will be used. We will update the table using the update.js file. The javascript code for the following is: Here we …
In this tutorial, we will learn how to query data in a table from the Nodejs application by connecting to the MySQL database server. Selecting data from a MySQL table using NodeJS To select all the data from the table, the SELECT statement will be used. Here we will use the database named app which …
In this tutorial, we will learn how to insert rows in a table from a Nodejs application in a MySQL database server. Inserting single row using Nodejs First, we will learn how to insert a single row in the table named info of the database app. The code below is written in the javascript file …
In this tutorial, we will learn how to create tables in the MySQL database server from the Nodejs application. Connecting to MySQL database server First of all, we connect our Nodejs application to the MySQL database server. For that, the code given below will set up the connection. Here we have first connected to the …
In this tutorial, we will learn what BIT datatype, its syntax, its examples and how to convert the data from and to the BIT datatype is. This is going to be an exciting tutorial, so stay tuned till the end, and you will learn everything about the BIT datatype in MySQL. Introduction to BIT in …