MariaDB offers the JSON column type, which allows one to save JSON files and query their contents in a structured way. During experiments with this type, I found missing syntax highlighting of several ...

MariaDb 10.11+ (at least) has the command; "STATUS" which works with and without a trailing ';' If I run this command on a MariaDb server locally or remotely using the CLI mysql client it responds ...

「HeidiSQL」は、オープンソースのデータベース管理ソフト。Windows XP/Vista/7/8に対応する寄付歓迎のフリーソフトで、本ソフトの公式サイトからダウンロードできる。USBメモリに入れて持ち運べるポータブルアプリも用意されている。 本ソフトを利用すると ...

I feel kinda silly here. I realize that I’ve never made a while loop in MySQL or MariaDB. Now that I’m actually trying to do it, it’s proving to be quite the task. Normally I would do all of this in ...