官术网_书友最值得收藏!

Extended bit-wise operations

In MySQL 5.7, bit-wise operations and functions were working for BigInt (64-bit integer) data types only. We needed to pass BIGINT as an argument and it would return the result as BIGINT. In short, it had maximum range up to 64 bits to perform operations. A user needs to do conversion to the BIGINT data type in case they want to perform it on other data types. This typecasting was not feasible for data types larger than 64 bits as it would truncate the actual value, which resulted in inaccuracy of data.

MySQL 8 has improved bit-wise operations by enabling support for other binary data types such as Binary, VarBinary, and BLOB. This makes it possible to perform bit-wise operations on larger than 64-bit data. No more typecasting needed! This allows the taking of arguments and returning results larger than 64 bits.

主站蜘蛛池模板: 新余市| 北辰区| 庆阳市| 亚东县| 赤水市| 绥江县| 海门市| 彩票| 邵武市| 班戈县| 齐河县| 连南| 怀宁县| 琼结县| 深水埗区| 陆河县| 永吉县| 商河县| 大余县| 平湖市| 怀来县| 旺苍县| 长治市| 四子王旗| 巴东县| 姚安县| 永济市| 元谋县| 大宁县| 静海县| 宽甸| 湟源县| 应用必备| 文成县| 甘南县| 遂川县| 尤溪县| 依兰县| 达拉特旗| 武川县| 平顺县|