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 INSTR | Case Insensitive Position of String in String

MySQL INSTR Function is an inbuilt function in MySQL. It finds the first position of occurrence of a substring in another string. Moreover, it performs the search in a case-insensitive manner. In this article, we will discuss the MySQL INSTR Function. Also, we will discuss a few examples of using ...
Read More

MySQL ASCII Function | Return ASCII Value of First Character

MySQL ASCII is an inbuilt function in MySQL. It returns the ASCII value of the first character of the input string to it. In this article, we will discuss the MySQL ASCII Function. Also, we will discuss a few examples of using it. Syntax ASCII (string) Parameters The MySQL ASCII ...
Read More

MySQL INSERT Function | Insert String Within a String

MySQL INSERT function is an inbuilt function in MySQL. It inserts a string within another string removing the corresponding characters from the original string. In this article, we will discuss the MySQL INSERT Function. Also, we will discuss a few examples of using it. Syntax INSERT(string, position, length, replaceString) Parameters ...
Read More

MySQL FIND_IN_SET | String Position in List of Strings

MySQL FIND_IN_SET is an inbuilt function in MySQL. It returns the position of a string in a list of string separated by commas. Also, the function performs the search in a case-insensitive manner. In this article, we will discuss the MySQL FIND_IN_SET Function. Also, we will discuss a few examples ...
Read More

MySQL FORMAT Function | Format a Number after Rounding

The FORMAT Function is an inbuilt function in MySQL. It converts a number in a format like "#,###,###.###" after rounding it to a specified number of decimal places. Also, it returns the number as a string. In this article, we will discuss the MySQL FORMAT Function. Also, we will discuss ...
Read More

MySQL FIELD Function | Get Position of Value in a List

MySQL FIELD is an inbuilt function in MySQL. It returns the index position of a value in a list of values. It compares the position of a value in a list of remaining values in a case-insensitive search. In this article, we will discuss the MySQL FIELD Function. Also, we ...
Read More

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

View All Articles >