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 LENGTH Function | Length of String

MySQL LENGTH is an inbuilt function in MySQL. It returns the length of the input string according to a total number of bytes of the characters. Therefore, it does not ignore whether the characters are single-byte or multi-bytes. It counts a single byte character as 1 and a 2-byte character ...
Read More

MySQL CHARACTER_LENGTH Function | Length of String

MySQL CHARACTER_LENGTH is an inbuilt function in MySQL. It returns the length of the input string by counting the number of characters. Also, it ignores whether the characters are single-byte or multi-bytes. It simply counts the number of characters. In this article, we will discuss the MySQL CHARACTER_LENGTH Function. Note: ...
Read More

MySQL CHAR_LENGTH Function | Length of String

MySQL CHAR_LENGTH is an inbuilt function in MySQL. It returns the length of the input string by counting the number of characters. Also, it ignores whether the characters are single-byte or multi-bytes. It simply counts the number of characters. In this article, we will discuss the MySQL CHAR_LENGTH Function. Also, ...
Read More

MySQL RIGHT | Extract Characters from Right of String

MySQL Right is an inbuilt function in MySQL. It extracts a number of characters from a string starting from the right. In this article, we will discuss the MySQL Right Function. Also, we will discuss a few examples of using it. Also, you can read about MySQL LEFT Function. Syntax ...
Read More

MySQL LEFT | Extract Characters from Left of String

MySQL Left is an inbuilt function in MySQL. It extracts a number of characters from a string starting from the left. In this article, we will discuss the MySQL Left Function. Also, we will discuss a few examples of using it. Also, you can read about MySQL RIGHT Function. Syntax ...
Read More

MySQL RPAD Function | Pad a String with Another String

MySQL RPAD is an inbuilt function in MySQL. It pads a string with specified characters on the right up to a given length. In this article, we will discuss the MySQL RPAD Function. Also, we will discuss a few examples of using it. You can also read about MySQL LPAD ...
Read More

MySQL LPAD Function | Pad a String with Another String

MySQL LPAD is an inbuilt function in MySQL. It pads a string with specified characters on the left up to a given length. In this article, we will discuss the MySQL LPAD Function. Also, we will discuss a few examples of using it. You can also read about MySQL RPAD ...
Read More

MySQL SPACE Function | String Specified Space Characters

MySQL SPACE is an inbuilt Function in MySQL. It returns a string containing a specified number of space characters. In this article, we will discuss the MySQL SPACE Function. Also, we will discuss a few examples of using it. Syntax SPACE (num_of_characters) Parameters The MySQL SPACE Function expects only one ...
Read More

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

View All Articles >