Newbie Area Revolution

aku pengen pake json di mariadb, yang bukan hanya alias dari longtext. untungnya mereka punya plugin untuk itu, namanya "mysql_json". setelah baca2 panduan, ada beberapa metode yang digunakan untuk install plugin. .\mariadb-plugin.exe --basedir="C:\Program Files\MariaDB 11.1" --datadir="C:\Program Files\MariaDB 11.1\data" --plugin_dir="C:\Program Files\MariaDB 11.1\lib\plugin" --my-print-defaults="C:\Program Files\MariaDB 11.1\bin" mysql_json enable gagal terus, error: Cannot read plugin config file mysql_json. File does not exist. .\mariadbd.exe --load-plugin=mysql_json .\mariadbd.exe --load-plugin=type_mysql_json .\mariadbd.exe --load-plugin-add=mysql_json .\mariadbd.exe --load-plugin-add=type_mysql_json gak fungsi, ketika dieksekusi blank saja INSTALL SONAME 'type_mysql_json berhasil, untuk ngecek bisa eksekusi "show plugins"

1. MySQL/MariaDB. gak paham sama sekali, gimana cara kerja skrip ini. https://stackoverflow.com/a/5081980 set @awal := '2023-03-01', @akhir := '2023-03-31'; SELECT @awal + INTERVAL a + b DAY `date` FROM (SELECT 0 a UNION SELECT 1 a UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 UNION SELECT 5 UNION SELECT 6 UNION SELECT 7 UNION SELECT 8 UNION SELECT 9 ) d, (SELECT 0 b UNION SELECT 10 UNION SELECT 20 UNION SELECT 30 UNION SELECT 40) m WHERE @awal + INTERVAL a + b DAY <= @akhir ORDER BY a + b limit 999 2. MariaDB. keren banget ini, langsung paham (output nya sama dengan #1). https://stackoverflow.com/a/54833745 https://mariadb.com/kb/en/sequence-storage-engine/ set @awal := '2023-03-01', @akhir := '2023-03-31'; SELECT @awal + interval seq day as `date` FROM seq_0_to_365 WHERE @awal + interval seq day <= @akhir limit 999

https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-debian-10

https://jira.mariadb.org/browse/MDEV-20687 it is still a bug my friend, because on mysql it is just work.