Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...

I recently was talking to someone over IRC who was helping me with a PHP app that was giving me trouble. The extremely helpful individual asked me to let him know the value of a certain field in a ...

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 ...