Big Data and Hadoop Training @$80 or Rs. 6,000 only - valid till Oct 17th Apply Now!

Mysql Length Function

Ads
 

Mysql Length Function

The Tutorial already illustrate you an example to find the length of the String. Now this section of tutorial helps you to find the Length Function in Mysql.

The Tutorial already illustrate you an example to find the length of the String. Now this section of tutorial helps you to find the Length Function in Mysql.

Mysql Length Function

     

The Tutorial already illustrate you an example to find the length of the String. Now this section of tutorial helps you to find the Length Function in Mysql. The Query length('Roseindia.net') is used to compute the length of characters in Roseindia.net under the fieldname Length of string.

length(Roseindia.net) : The Query given below is used to compute the length of string enclosed in single quotes under the specified column name.

 

 

 

 

Query:-

mysql> select length('Roseindia.net')as Lengthofstring;

Output:-

+----------------+
| Lengthofstring |
+----------------+
|             13 |
+----------------+
1 row in set (0.00 sec)

Ads

Ads