mysql length function : calculate length of a column
mysql length function : calculate length of a column
Function length()
- Return the length of the string
Usages
SELECT CustomerName, LENGTH(CustomerName) AS LengthOfName FROM Customers;
| Tablenames | Records |
|---|---|
| Customers | 91 |
| Categories | 8 |
| Employees | 9 |
| OrderDetails | 2155 |
| Orders | 830 |
| Products | 77 |
| Shippers | 3 |
| Suppliers | 29 |