这个数据库位运算怎么解释? SELECT * FROM BOOK WHERE BOOK.CATEGORYID & 0xFF00 = 0x0A00怎样的数据才能符合条件呢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是导出的建表SQLCREATE TABLE `BOOK` ( `categoryId` bit(16) NOT NULL default '\0\0', `name` varchar(50) default NULL, PRIMARY KEY (`categoryId`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;该怎么用insert 插入bit型的数据呢? mysql> CREATE TABLE `BOOK` ( -> `categoryId` bit(16) NOT NULL default '\0\0', -> `name` varchar(50) default NULL, -> PRIMARY KEY (`categoryId`) -> );Query OK, 0 rows affected (0.09 sec)mysql> insert into BOOK values (0x0101,'hhhhh');Query OK, 1 row affected (0.06 sec)mysql> select * from book;+------------+-------+| categoryId | name |+------------+-------+| | hhhhh |+------------+-------+1 row in set (0.00 sec)mysql> select hex(categoryId),name from book;+-----------------+-------+| hex(categoryId) | name |+-----------------+-------+| 101 | hhhhh |+-----------------+-------+1 row in set (0.05 sec)mysql> mysql语句错误,在线等! 根据表中部分内容截取,更新其他字段 关于mysql的模糊查询中占位符的问题 update 的疑问 求一条统计用的sql mysql乱码问题?(是万火急) 在windows中,mysql的表名不能用大写字母??!! mysql下,怎么执行一个外部sql文件,对空数据库建表,建数据 qdatetime 怎么插入数据库啊 SQL查询问题,急! 请问如何在论坛中实现文章翻到上一主题下一主题!SQL语句怎么写? 字符串编号自动生成问题
CREATE TABLE `BOOK` (
`categoryId` bit(16) NOT NULL default '\0\0',
`name` varchar(50) default NULL,
PRIMARY KEY (`categoryId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;该怎么用insert 插入bit型的数据呢?
-> `categoryId` bit(16) NOT NULL default '\0\0',
-> `name` varchar(50) default NULL,
-> PRIMARY KEY (`categoryId`)
-> );
Query OK, 0 rows affected (0.09 sec)mysql> insert into BOOK values (0x0101,'hhhhh');
Query OK, 1 row affected (0.06 sec)mysql> select * from book;
+------------+-------+
| categoryId | name |
+------------+-------+
| | hhhhh |
+------------+-------+
1 row in set (0.00 sec)mysql> select hex(categoryId),name from book;
+-----------------+-------+
| hex(categoryId) | name |
+-----------------+-------+
| 101 | hhhhh |
+-----------------+-------+
1 row in set (0.05 sec)mysql>