I'm running a Pixelbook with Crostini, and my MariaDB database sits in my linux instance. Sometimes, weird things happens and my root user loses the password and I can't access my database. So here is…

For a while I was sure that UNION ALL had better performance when dealing with multiple matches from SELECT * FROM table. But recently I revisited my code and the performance is negligible. My code is…