嘿嘿,回者就能得一分。bit 这种数据类型占用的空间。每一条占几个字节?关键是如何得知。
比如这个:mysql> show create table bittest;
+---------+-------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+-------------------------------------------------------------------------------------------+
| bittest | CREATE TABLE `bittest` (
`bittest` bit(37) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
+---------+-------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
比如这个:mysql> show create table bittest;
+---------+-------------------------------------------------------------------------------------------+
| Table | Create Table |
+---------+-------------------------------------------------------------------------------------------+
| bittest | CREATE TABLE `bittest` (
`bittest` bit(37) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
+---------+-------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货