MySQL

What is MySQL?

MySQL is a Database System used on Web. It runs on a server and is ideal for both small and large applications. Also, it uses the standard SQL Language. It is fast, reliable and most importantly free to use and download.

Learn about MySQL Database and find questions to common problems on Concatly!

Featured Articles

You must have implemented Pagination in MySQL using Limit Offset queries. You might have never ...
Read More
In this post, we will discuss the inbuilt Mathematical Functions in MySQL. These functions are ...
Read More
In this article, I will be discussing the basics of using MySQL Triggers on DML ...
Read More

´╗┐View All Articles >

Recent Articles

MySQL REPEAT Function | Repeat Strings

MySQL REPEAT is an inbuilt function in MySQL. It repeats a string for a specified number of times. Both the string and the number are the arguments to the function. In this article, we will discuss the MySQL REPEAT Function. Also, we will discuss a few examples of using it ...
Read More

MySQL Position Function | Position of Substring in String

MySQL Position is an inbuilt function in MySQL. It returns the position of the first occurrence of a substring in a string. However, if the substring does not exist then it returns 0. Moreover, the function performs a case-insensitive search (uppercase and lowercase characters are the same). In this article, ...
Read More

MySQL Locate Function | Position of Substring in String

MySQL Locate is an inbuilt function in MySQL. It returns the position of the first occurrence of a substring in a string. However, if the substring does not exist then it returns 0. Moreover, the function performs a case-insensitive search (uppercase and lowercase characters are the same). In this article, ...
Read More

MySQL STRCMP Function | Compare Two Strings

MySQL STRCMP is an inbuilt Function in MySQL. It compares two strings and returns 0 if both of them are the same. Also, it returns -1 if the first string is smaller than the second and returns 1 on the other way round according to the sort order. In this ...
Read More

MySQL SUBSTRING_INDEX Function | Substring By Delimiter

MySQL SUBSTRING_INDEX is an inbuilt Function in MySQL. It returns a substring before the number of occurrences of a delimiter. In this article, we will discuss the MySQL SUBSTRING_INDEX Function. Also, we will discuss a few examples of using it. Moreover, you can also go through MySQL Substring Function which ...
Read More

MySQL REVERSE Function | Reverse String

Reverse Function reverses a string and returns the result. It is an inbuilt Function which works from MySQL 4.0 onwards. In this article, we will discuss the MySQL Reverse Function. Also, we will discuss a few examples of using it. Syntax REVERSE (string) Parameters The Reverse expects only one parameter ...
Read More

MySQL LOWER Function | Convert Text to Lowercase

MySQL LOWER is an inbuilt Function in MySQL. It converts a text to lowercase in MySQL. In this article, we will discuss the MySQL LOWER Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL LCASE Function. Syntax LOWER (string) Parameters The Function ...
Read More

MySQL LCASE Function | Convert Text to Lowercase

MySQL LCASE is an inbuilt Function in MySQL. It converts a text to lowercase in MySQL. In this article, we will discuss the MySQL LCASE Function. Also, we will discuss a few examples of using it. This function is synonymous to MySQL LOWER Function. Syntax LCASE (string) Parameters The Function ...
Read More

MySQL RTRIM Function | Remove Trailing Spaces from String

RTRIM is an inbuilt Function in MySQL which removes unwanted trailing spaces from a string in MySQL. Data present in tables might not always what we expect. There can be unwanted spaces trailing the strings. RTRIM Function removes those unwanted spaces. In this article, we will discuss the MySQL RTRIM ...
Read More

MySQL LTRIM Function | Remove Leading Spaces from String

LTRIM is an inbuilt Function in MySQL which removes unwanted leading spaces from a string in MySQL. Data present in tables might not always what we expect. There can be unwanted spaces leading the strings. LTRIM Function removes those unwanted spaces. In this article, we will discuss the MySQL LTRIM ...
Read More

View All Articles >