ASAlex Skripovinskripov.co·Mar 23, 2023 · 5 min readMySQL documentationA few days ago I had a situation when I had to run some query on my MySQL server without access to the internet. And what I discovered. The default server build is compiled with MySQL docs on board :) Just in case, I needed JSON_SCHEMA_VALIDATION_REP...00
ASAlex Skripovinskripov.co·Mar 18, 2023 · 1 min readFunny trick in MySQLA few days ago I needed to get max unsigned big int in MySQL. Here is a little trick on how to get it right away: mysql> SELECT ~0; +----------------------+ | ~0 | +----------------------+ | 18446744073709551615 | +-----------------...00
ASAlex Skripovinskripov.co·Mar 16, 2023 · 4 min readIntersect and Except in MySQLSince version 8.0.31, MySQL supports INTERSECT and EXCEPT. I don't know how I missed that, but finally. It is a part of MySQL now. To test it I ran MySQL docker container. Here are the schema and data: CREATE TABLE `counters` ( `name` varchar(32) D...00