我们如何将 BIT_LENGTH() 函数应用于 MySQL 表的列?
mysqlmysqli database
当 BIT_LENGTH() 函数应用于 MySQL 表的列时，它将返回存储在表的列中的字符串的位数。以下示例将对此进行演示。
示例
假设我们想从表"Student"中找到存储在列"Name"和"Address"中的字符串的长度，那么我们可以编写以下查询 −
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)
