- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 145字
- 2021-08-20 10:06:05
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.
- 數據庫系統原理及MySQL應用教程(第2版)
- Python數據分析入門與實戰
- Twilio Best Practices
- Java游戲服務器架構實戰
- Java持續交付
- C語言從入門到精通(第4版)
- Kotlin Standard Library Cookbook
- Bootstrap 4:Responsive Web Design
- INSTANT Passbook App Development for iOS How-to
- Developing SSRS Reports for Dynamics AX
- 并行編程方法與優化實踐
- MyBatis 3源碼深度解析
- Web開發的平民英雄:PHP+MySQL
- 從零開始學Python大數據與量化交易
- 自己動手構建編程語言:如何設計編譯器、解釋器和DSL