How can we apply BIT_LENGTH() function on the column/s of MySQL table?

When BIT_LENGTH() function is applied to column/s of MySQL table then it will return the number of bits of the strings that are stored in the column/s of a table. Following example will demonstrate it.

Example

Suppose from a table ‘Student’ we want to find the length of strings stored in column ‘Name’ and ‘Address’, then we can write following query −

mysql> Select Name, Address, BIT_LENGTH(Name) As 'Name in Bits', BIT_LENGTH(Address) AS 'Address in Bits' from Student;
+---------+---------+--------------+-----------------+
| Name    | Address | Name in Bits | Address in Bits |
+---------+---------+--------------+-----------------+
| Gaurav  | Delhi   | 48           | 40              |
| Aarav   | Mumbai  | 40           | 48              |
| Harshit | Delhi   | 56           | 40              |
| Gaurav  | Jaipur | 48            | 48              |
+---------+---------+--------------+-----------------+
4 rows in set (0.00 sec)

Karthikeya Boyini

Published on 19-Feb-2018 13:48:44

• Related Questions & Answers
• How can we apply COALESCE() function on a MySQL table’s data value?
• How can we modify column/s of MySQL table?
• How can we use MySQL EXPORT_SET() function with column of a table?
• How can we apply a NOT NULL constraint to a column of an existing MySQL table?
• How MySQL CONCAT() function, applied to the column/s of a table, can be combined with the column/s of other tables?
• How can we add day/s in the date stored in a column of MySQL table?
• How to apply EXTRACT() function on the dates stored in MySQL table?
• How can we apply UNIQUE constraint to the field of an existing MySQL table?
• How can we use MySQL REVERSE() function on column’s data along with WHERE clause?
• How can we use MySQL POWER() function with the column’s data values?
• How can we apply AUTO_INCREMENT to a column?
• How can we apply the PRIMARY KEY constraint to the field of an existing MySQL table?
• How can we change the data type of the column in MySQL table?
• How can we remove a column from MySQL table?
• How can we create a new MySQL table by selecting specific column/s from another existing table?