Mysql String Length

Ads
 

Mysql String Length

The Tutorial illustrate an example from 'Mysql String Length'.To grasp this example we use Length ( ) query that returns the length size of string.

The Tutorial illustrate an example from 'Mysql String Length'.To grasp this example we use Length ( ) query that returns the length size of string.

Mysql String Length

     

Mysql Length is used to return the length of the String.

Understand with Example

The Tutorial illustrate an example from 'Mysql String Length'.To grasp this example we use Length ( ) query that returns the length size of string.

Length('Girish')as  StrLength: The Syntax is used to return the length size of string 'Girish' as fieldname StrLength.  

Query:-

 

 

 

mysql> Select Length('Girish')as StrLength;

Output:-

+-----------+
| StrLength |
+-----------+
|         6 |
+-----------+
1 row in set (0.00 sec)

Ads

Ads