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.

Mysql Length Function

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)

Tutorials

  1. PHP SQL Timestamp
  2. MySQL Append Column
  3. Mysql where
  4. Mysql Update
  5. Mysql Now Current DateTime
  6. Mysql Multiply
  7. Mysql Multiplication Columns
  8. Mysql Multiple Date Insert
  9. Mysql Mod Function
  10. Mysql Minus
  11. Mysql Minimum Query
  12. Mysql MidString
  13. Mysql Merge Statement
  14. Mysql Max Date
  15. Mysql Math Function
  16. Mysql Ltrim
  17. Mysql Lpad
  18. Mysql Lpad Function
  19. Mysql Lower Case
  20. Mysql Looping
  21. Mysql Loop in Procedure
  22. Mysql Loader Examples
  23. Mysql Loader Tutorial
  24. Mysql Loader Control File
  25. Mysql List Tables
  26. Mysql List
  27. Mysql Limit
  28. Mysql like syntax
  29. Mysql Like Operator
  30. Mysql Like Command
  31. Mysql Like Operator
  32. Mysql Length Function
  33. Mysql String Length
  34. Mysql Left Function
  35. Mysql Left
  36. Mysql Last Record
  37. Mysql last day of month
  38. Mysql Last
  39. Mysql Difference
  40. MySQL Addition