- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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)
Updated on 20-Jun-2020 08:15:53
- 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?
Advertisements