MySQL Examples and Tutorials
In this tutorial, we will learn to connect a MySQL database to PHP by different methods. We will use the MariaDB which is a fork of MySQL throughout the tutorial. Note that, all the syntaxes, statements and codes given below are the same for MySQL as well as MariaDB. Therefore, you can choose either MySQL …
In this tutorial, we will study the Prepared statement in MySQL. We will learn what is a prepared statement, how it is used, and the advantages of using a prepared statement. Introduction A prepared statement is a SQL query that is stored in the server so that it can be reused multiple times. Prepared statements …
MySQL Storage engines is a very important topic that you must study if you are planning to make a career in the database domain. In this tutorial, we will learn what is storage engines in MySQL, what are its types, information about all storage engines that MySQL supports and how to specify a storage engine …
In MySQL, there are some limitations to the searching methods such as LIKE, boolean search and natural language search. These methods show the results of only particular keywords that users enter. Sometimes, these keywords are too short to search for particular information. To overcome this problem, MySQL provides us with the full-text searching method called …
In this article, I will be introducing you to the Last_Value function in MySQL. This function is used for getting the last value of a column in an ordered set query. Let’s move ahead and learn more about it! Also read: MySQL First_Value Function – Beginner’s Guide Introduction to MySQL Last_Value() function The Last_Value function …
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 …