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

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.

主站蜘蛛池模板: 长垣县| 平果县| 高邮市| 长寿区| 古蔺县| 张家港市| 巴楚县| 海口市| 邹平县| 太谷县| 梧州市| 山西省| 三亚市| 积石山| 五指山市| 长岭县| 镇安县| 木兰县| 楚雄市| 大化| 松阳县| 乌拉特中旗| 六枝特区| 土默特左旗| 民权县| 余江县| 洛隆县| 定安县| 阳东县| 蒲城县| 综艺| 曲周县| 肇源县| 句容市| 图木舒克市| 宜丰县| 广南县| 定安县| 讷河市| 镇安县| 广饶县|