MySQL Examples and Tutorials
In this tutorial, we will study the MySQL CHAR_LENGTH() function. The CHAR_LENGTH() function is used to return the length of the string as the number of characters in it. The CHARACTER_LENGTH() function is the same as CHAR_LENGTH() function. Both of them do the same thing i.e., returning the number of characters in a string. For …
MySQL CHAR_LENGTH() – How to find the number of characters in a string? Read More »
In this tutorial, we will study the MySQL LENGTH() function. While working with tables in MySQL, there may be a situation in which you may want to calculate the length of a value in a column. For this purpose, MySQL provides us with the LENGTH() function. The MySQL LENGTH() function returns the length of a …
MySQL LENGTH() Function – How to measure the length of strings in bytes? Read More »
In this tutorial, we will learn about the MySQL REVERSE() function. MySQL REVERSE() function is a string function that is used to reverse a given argument and return the result. Suppose you have 123 as an argument in the REVERSE() function, then the result returned would be 321. The REVERSE() function is usually used with …
MySQL REVERSE() Function – How to reverse values in MySQL? Read More »
In a previous tutorial, we studied the MySQL CONCAT() function. Building on that, this tutorial will focus on the MySQL CONCAT_WS() function. The MySQL CONCAT_WS() function is used to concatenate or combine two or more expressions with a separator. This separator is added between the expressions and then we get our concatenated string as our …
In this tutorial, we will learn about the MySQL CONCAT() function. Suppose you have an Employee table that has separate columns for the first name and the last name of the employee. What if you had to display the full name (first name + last name) of the employee in MySQL? Such a query would …
In this tutorial, we will learn about the MySQL ASCII() function. The American Standard Code for Information Interchange, or ASCII, is a character encoding standard for electronic communication. Since computers can only understand numbers, the ASCII numeric codes are used to represent text in computers. You may read more about ASCII over here. The MySQL ASCII() …
MySQL ASCII() Function – How to find ASCII values in MySQL? Read More »
In this tutorial, we will learn about the MySQL UNION operator. Suppose you encounter a situation in which you need to combine the results of two different queries. What would you do in such a case? MySQL provides us with the UNION operator for this purpose. MySQL UNION is used to combine the result-set of …
MySQL UNION – Show Combined Data From Multiple MySQL Tables Read More »
In this tutorial, we will learn about MySQL Alias. Suppose you have a query in which you are displaying the Department column and the COUNT(*) column which returns the number of employees in each department. To us programmers, we can understand what COUNT(*) means but when you present your results to someone who doesn’t understand …
MySQL Alias – An Easy Way to Setup Aliases in MySQL Read More »
In this tutorial, we will learn about the MySQL HAVING Clause. The MySQL HAVING clause is used along with the GROUP BY clause. The HAVING Clause adds a condition to the groups and returns only those groups for whom the condition evaluates to true. In short, it restricts the rows returned by the GROUP BY …
In this tutorial, we will learn about the following MySQL aggregate functions – COUNT(), SUM() and AVG(). Suppose we want to count the number of employees from a table who are in the Marketing department. Or what if we wanted to find the average salary of employees in a company? How about situations in which …
MySQL Aggregate Functions – COUNT(), SUM() and AVG() Read More »